https://community.qlik.com/t5/App-Development/Exporting-currency-in-correct-format/m-p/2432410#M96718 <P>Hello all,</P> <P>I want the following output, e.g.:</P> <UL> <LI>0 should be displayed and exported as 0 €</LI> <LI>5000&nbsp;should be displayed and exported as 5.000,00 €</LI> </UL> <P>&nbsp;</P> <TABLE style="border-style: dotted; width: 100%;" border="1" width="100%"> <TBODY> <TR> <TD width="12.5%">Idea No.</TD> <TD width="12.5%">Formula</TD> <TD width="25%">Number Format</TD> <TD width="25%">Displayed Output in Qlik Sense</TD> <TD width="25%">Exported Output in Excel</TD> </TR> <TR> <TD width="12.5%">1</TD> <TD width="12.5%">=Money(round(..., .01))</TD> <TD width="25%">Automatically</TD> <TD width="25%"> <OL> <LI>0 €</LI> <LI>5.000,00 €</LI> </OL> </TD> <TD width="25%"> <OL> <LI>000 €</LI> <LI>5.000 €</LI> </OL> </TD> </TR> <TR> <TD width="12.5%">2</TD> <TD width="12.5%">=round(..., .01)</TD> <TD width="25%">Currency with: #.##0,00 €;-#.##0,00 €</TD> <TD width="25%"> <OL> <LI>0 €</LI> <LI>5.000,00 €</LI> </OL> </TD> <TD width="25%"> <OL> <LI>,000 €</LI> <LI>5000,000 €</LI> </OL> </TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>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.</P> <P>&nbsp;</P> <P>Why is my displayed output different to the exported output and how can I change that?&nbsp;</P> Tue, 19 Mar 2024 13:46:06 GMT steasy 2024-03-19T13:46:06Z https://community.qlik.com/t5/App-Development/Exporting-currency-in-correct-format/m-p/2432410#M96718 <P>Hello all,</P> <P>I want the following output, e.g.:</P> <UL> <LI>0 should be displayed and exported as 0 €</LI> <LI>5000&nbsp;should be displayed and exported as 5.000,00 €</LI> </UL> <P>&nbsp;</P> <TABLE style="border-style: dotted; width: 100%;" border="1" width="100%"> <TBODY> <TR> <TD width="12.5%">Idea No.</TD> <TD width="12.5%">Formula</TD> <TD width="25%">Number Format</TD> <TD width="25%">Displayed Output in Qlik Sense</TD> <TD width="25%">Exported Output in Excel</TD> </TR> <TR> <TD width="12.5%">1</TD> <TD width="12.5%">=Money(round(..., .01))</TD> <TD width="25%">Automatically</TD> <TD width="25%"> <OL> <LI>0 €</LI> <LI>5.000,00 €</LI> </OL> </TD> <TD width="25%"> <OL> <LI>000 €</LI> <LI>5.000 €</LI> </OL> </TD> </TR> <TR> <TD width="12.5%">2</TD> <TD width="12.5%">=round(..., .01)</TD> <TD width="25%">Currency with: #.##0,00 €;-#.##0,00 €</TD> <TD width="25%"> <OL> <LI>0 €</LI> <LI>5.000,00 €</LI> </OL> </TD> <TD width="25%"> <OL> <LI>,000 €</LI> <LI>5000,000 €</LI> </OL> </TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>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.</P> <P>&nbsp;</P> <P>Why is my displayed output different to the exported output and how can I change that?&nbsp;</P> Tue, 19 Mar 2024 13:46:06 GMT https://community.qlik.com/t5/App-Development/Exporting-currency-in-correct-format/m-p/2432410#M96718 steasy 2024-03-19T13:46:06Z https://community.qlik.com/t5/App-Development/Exporting-currency-in-correct-format/m-p/2432429#M96723 <P>Your Excel and Qlik Sense are using different decimal and thousands separators. You can change them in the load script:</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="LRuCelver_0-1710857134405.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/162306i71C4E2AA65C23C99/image-size/medium?v=v2&amp;px=400" role="button" title="LRuCelver_0-1710857134405.png" alt="LRuCelver_0-1710857134405.png" /></span></P> <P>&nbsp;</P> Tue, 19 Mar 2024 14:05:43 GMT https://community.qlik.com/t5/App-Development/Exporting-currency-in-correct-format/m-p/2432429#M96723 LRuCelver 2024-03-19T14:05:43Z