Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
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 ?
Paul
Hi paulyeo11,
Try out the Num Qlik function. You can define the numerical format of your choice in the second parameter.
Example:
Num(Sum(Sales), '#,##0') --> without decimals. Rounded.
Num(Sum(Sales), '#,##0.00') --> with 2 decimal numbers.
Hope this solves your issue.
Regards,
Hi Yeo,
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...
Regards Wouter
Hi paulyeo11,
Try out the Num Qlik function. You can define the numerical format of your choice in the second parameter.
Example:
Num(Sum(Sales), '#,##0') --> without decimals. Rounded.
Num(Sum(Sales), '#,##0.00') --> with 2 decimal numbers.
Hope this solves your issue.
Regards,
Hi sir
Thank you , your suggestion is good . I can put those code in master items.
Paul Yeo
DIrector
TDS Technology (S) P/L
Whatsapp +65 9326 1804
www.tdstech.com<http://www.tdstech.com>
If you think that's a correct answer, mark my reply via 'Mark as Correct' option. I appreciate it