Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all,
I want the following output, e.g.:
Idea No. | Formula | Number Format | Displayed Output in Qlik Sense | Exported Output in Excel |
1 | =Money(round(..., .01)) | Automatically |
|
|
2 | =round(..., .01) | Currency with: #.##0,00 €;-#.##0,00 € |
|
|
My analytics team always export with the tick in keeping the table format, because they want to keep the colors. Therefore their output in excel is like the exported output in excel as above. Not ticking would be a solution for the decimals, but will remove the colored cells.
Why is my displayed output different to the exported output and how can I change that?
Your Excel and Qlik Sense are using different decimal and thousands separators. You can change them in the load script: