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
For more information, see Mail & Deploy Advanced: How to use cell formatting to create customized tables in Mail & Deploy.
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 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 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 ...How to synchronize cell insertion in an Excel report in Mail & Deploy (with example)?
FIRST CREATED ON 31 Jan 2024 I AUTHOR Emma Camacho Synchronizing cell insertion in an Excel report within Mail & Deploy ensures that your data is accurately aligned and formatted. Here's an example to guide you through the process: If you need a ...What is Report Culture Awareness, and how does it impact Mail & Deploy reports?
FIRST CREATED ON 30 Apr 2020 I AUTHOR Emma Camacho A culture is a set of rules that specify how numbers and dates are formatted (Windows Regional Settings). Generally speaking, the culture defines in what format numbers and dates are being presented ...