Qlik Sense Can i set the number format to Number 1,000 ?

[paulyeo11]

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

[wouterlely]

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

[jasonmomoa · Accepted solution]

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,

[paulyeo11]

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>

[jasonmomoa]

If you think that's a correct answer, mark my reply via 'Mark as Correct' option. I appreciate it