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

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,' ##0.0%'))


Info

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

    • 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 ...

    • 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 ...

    • 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) & ...

    • 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 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 ...