How to add symbols to negative and positive numbers?

How to add symbols to negative and positive numbers?

FIRST CREATED ON 17 Jun 2025 I AUTHOR Emma Camacho

To add symbols to the numeric cells (negative and positive numbers):

Use the following expression in Qlik for the column f3 with symbols:



Expression: num(f3, CHR(9650) & '#,###' & ';' & CHR(9660) & '#,###')

To get the following table in Powerpoint


​
Looking for Additional Guidance?
If you require more detailed information or further assistance, please visit our comprehensive Online Documentation. Our resources are designed to help you navigate all features and functionalities effectively.


    • Related Articles

    • How to add the user name to a Report when requested by M&D Hub

      FIRST CREATED ON 19 Aug 2025 I AUTHOR Emma Camacho Add a parameter with the following Hub Input Field options Type: Drop-Down Field Source: User Name Add an Expression Element and insert the previously created parameter, you can then add it to the ...

    • How to export numbers formatted as percentage in a CSV report ?

      FIRST CREATED ON 25 April 2025 I AUTHOR Emma Camacho If the App has a table with the following number format the output of a CSV Report looks like this Edit the column's expression as follows to get the correct format text(num( measure1 / measure2,' ...

    • How to set Culture to a Report?

      FIRST CREATED ON 23 May 2023 I AUTHOR Emma Camacho Configuring the culture for a report ensures correct date formats, currency, and locale-specific settings. This article shows you how to set it up: (1) Set the Culture in the General Report Settings ...

    • How to show/hide sheets in Microsoft Excel reports conditionally?

      FIRST CREATED ON 19 Dec 2024 I AUTHOR Emma Camacho It is possible to show/hide sheets in Microsoft Excel reports using the Condition property of Elements together with the Exception Behavior. Follow the example to hide Sheets if the CY Sales = 0 and ...

    • How to sort the Templates when using more than one in a Report

      FIRST CREATED ON 4 November 2024 I AUTHOR Emma Camacho This recommendations applies to: * The Report has more than one template * The definition of the which templates to use to create the Report is stored in a field * A specific sorting order is ...