4 Replies Latest reply: Feb 13, 2018 4:46 AM by Xavier Garcia

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

Yeo Poh sai Feb 12, 2018 1:24 AM

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

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

Wouter Lely Feb 12, 2018 10:53 AM (in response to Yeo Poh sai)

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
Like Show 0 Likes (0)

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

Xavier Garcia Feb 13, 2018 3:45 AM (in response to Yeo Poh sai)

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,
Like Show 0 Likes (0)

Actions
- Re: Qlik Sense Can i set the number format to Number 1,000 ?
  
  Yeo Poh sai Feb 13, 2018 4:14 AM (in response to Xavier Garcia)
  
  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>
  
  Like Show 0 Likes (0)
  
  Actions
  - Re: Qlik Sense Can i set the number format to Number 1,000 ?
    
    Xavier Garcia Feb 13, 2018 4:46 AM (in response to Yeo Poh sai)
    
    If you think that's a correct answer, mark my reply via 'Mark as Correct' option. I appreciate it
    
    Like Show 0 Likes (0)
    
    Actions

Go to original post