Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Format Number (in Thousand)

Hi guys,

just a quick question,

How to display number with thousand format in qlik sense ?

Usually in Excel, I just add dot or comma in custom format to display my number in thousand.

Can Qlik sense do that ?

Please advice

Thanks

Henry

1 Solution

Accepted Solutions
mek
Employee
Employee

Hi again,

There is currently no support for automated suffixes when formatting (we are looking into this). However it is still possible to achieve what you want by formatting directly in the measure expression.

Assuming you have a measure Sum(Sales) then the expression would look like this:

if(Sum(Sales) > 1000000,  num(Sum(Sales)/1000000, '#.##0,##M', ',', '.'),

    if(Sum(Sales) > 1000, num(Sum(Sales)/1000,  '#.##0,##K', ',', '.'), num(Sum(Sales), '#.##0,##', ',', '.')))

Which would result in something like the following:

Formatting.PNG

View solution in original post

30 Replies
Gysbert_Wassenaar

I don't understand your question. The screenshot you posted already shows the thousand separator in action.


talk is cheap, supply exceeds demand
saurabh5
Creator II
Creator II

In the screen shot it shows that it is seperating just make a change in your format pattern to ###,##0

Not applicable
Author

Let say my number is 10.000.000 (ten million), I want my number show 10 (which is in million).

in Excel, I usually just add (dot) to cover thousand.

Anonymous
Not applicable
Author

Hi Henry,

By default the values gets formatted in qlik sense...

Like if it is 100,000 then the result is "100k"

So make the number formatting to auto.

Thanks,

Vignesh

Not applicable
Author

But when I am using table, the result is not 100K but 100.000

Anonymous
Not applicable
Author

Yes Your right in table it will not get formatted...

Suggestions:

1.May be the Qlik tech team can fix this in the next release.

2.Use of third party extensions may resolve your needs.

Not applicable
Author

Hi  Henry

to format numbers , you can either do it via some script using num#(field_name,'###,##0') function, or else you can just simply go to the Number tab , select Number, then set how you would like your numbers to b displayed in that particular object.

Hope this helps

Best Regards

Dlamini

mek
Employee
Employee

Hi Henry,

What you want is typically achieved by having a measure with the same value that you would like to display. Since you want the numbers to be in thousands you simply divide the measure by 1000 (e.g. sum(Sales)/1000) and then adjust the format settings to use the desired separators;

Number formatting: Custom

Decimal sep: ,

Thousands sep: .

Pattern: #.##0

Regards,

Miralem

Anonymous
Not applicable
Author

Try changing the format pattern to:

###,##0