Discussion Board for collaboration related to QlikView App Development.
Hi, I want to display numbers with thousand separator '.' and two decimals.
LOAD * INLINE [
Drop Table Data;
But my numbers get displayed with hashes. How can I change that?
The the below:
it still doesn't show the thousand separators
But this is better than before! Thanks
It is just because the table has been INLINE loaded, so it pulls through with the Comma in it, if you are pulling from a numerical format it should be correct.
When I use this file as a basis, it still doesn't show the thousand separators
(ooxml, embedded labels, table is Tabelle1);
Num#(Zahl,'#.##0,00') AS Zahl
you can use bellow;
Num(Zahl,'#,##0.00') as Zahl2