Hello all,
I want the following output, e.g.:
- 0 should be displayed and exported as 0 €
- 5000 should be displayed and exported as 5.000,00 €
| Idea No. |
Formula |
Number Format |
Displayed Output in Qlik Sense |
Exported Output in Excel |
| 1 |
=Money(round(..., .01)) |
Automatically |
- 0 €
- 5.000,00 €
|
- 000 €
- 5.000 €
|
| 2 |
=round(..., .01) |
Currency with: #.##0,00 €;-#.##0,00 € |
- 0 €
- 5.000,00 €
|
- ,000 €
- 5000,000 €
|
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?
