

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Accepted Solutions


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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,


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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,


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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>


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
If you think that's a correct answer, mark my reply via 'Mark as Correct' option. I appreciate it
