Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

paulyeo11
Valued Contributor II

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

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

1 Solution

Accepted Solutions
jasonmomoa
Contributor

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

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,

4 Replies
wouterlely
New Contributor

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

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
Contributor

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

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
Valued Contributor II

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

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
Contributor

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

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

Community Browser