Since all my number display are with out decimal point .
it there a way to set the format to Number instead of now is Auto , and 1,000.00 to 1,000 ?
As far as I know you have to change Number Formatting in each chart individually. I don't believe there is a way to change the default settings of the Number Formatting...
Try out the Num Qlik function. You can define the numerical format of your choice in the second parameter.
Num(Sum(Sales), '#,##0') --> without decimals. Rounded.
Num(Sum(Sales), '#,##0.00') --> with 2 decimal numbers.
Hope this solves your issue.
Thank you , your suggestion is good . I can put those code in master items.
TDS Technology (S) P/L
Whatsapp +65 9326 1804
If you think that's a correct answer, mark my reply via 'Mark as Correct' option. I appreciate it
Retrieving data ...