Expert (advanced!) settings for export number formats in the Finance Report.
Exporting data from the Finance Report can be a complex task when it comes to number formats. Among other things it is affected by the format in the Qlik Sense application, the format in the extension, the format in your expressions and the regional settings on your computer and in Excel. Below are some advanced settings and tips but please only use these settings when you have tried the normal template and number formatting in the template application!
Add the variable used with advanced export formats to your Finance Report table. If you are uncertain of how this works, always start in the template application.
As you can see from the last column in the image above different rows get a different result depending on the format code used in the template. (Operating Earnings % have format #6 and all other rows have #4.) This settings corresponds with the selected ExportNumberFormat choosen in the Excel template if you use that.
If the Excel template is not used it is possible to apply an export number format using the dual value of the Report row. (More on that in this article.)
1. First step is to activate the Export Number Formats and set them to Manual.
2. Secondly, add as many number formats as needed. Each new format represent the corresponding number in RowNumExportFormatCode (see image from Excel above). For example if we need to change the export format for Calculation Operating Earnings in the example we need to add six (6) number formats where the last one will be the number format for that Calculation.
3. Check what variable is used and that is has the correct content. Variables are automatically created in the template script but any other expression or variable can be used as needed.