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

Change number format to thousand

Hi

I have values for measure as 100000, 2000000, 300000 etc. I want values to be resprented as 100k, 200k, 300k.

I used expression like below but i am values like 100, 200 instead of 100k, 200k

If(SUM([Vbl.Val./COCrcy]) >= 1000000,

   Num(SUM([Vbl.Val./COCrcy])/1000000, '#.##0 M'),

   Num(SUM([Vbl.Val./COCrcy])/1000, '#.##0 K')

  )

Can you please let me know what i am missing

Thanks

6 Replies
ramoncova06
Specialist III
Specialist III

is this in a table or a text object ?

if it inside a table go to numbers and change the symbol to "K"

for the one you were already working on remove the symbols from the num and use & to append them

the other option is

If(SUM([Vbl.Val./COCrcy]) >= 1000000,

   Num(SUM([Vbl.Val./COCrcy])/1000000, '#.##0')&'M',

   Num(SUM([Vbl.Val./COCrcy])/1000, '#.##0)&'K'

  )

ian_wilson
Former Employee
Former Employee

try this (i am using "Sales" instead "[Vbl.Val./COCrcy]"):

If(Sum(Sales) >= 1000000,

   Num(Sum(Sales)/1000000, '#.##0M'),

   Num(Sum(Sales)/1000, '#.##0K')

  )

Not applicable
Author

sorry about forgot to mention it is stacked bar chart. Not sure if it is still possible.

ian_wilson
Former Employee
Former Employee

The number formatting for the Y-axis and the value labels on the stacked bar chart in Qlik Sense are auto-formatted.  And they will display K and M as needed.  Here's an example of both K's and M's showing automatically with Qlik Sense:

qlikSenseBarChartNumFormatting.jpg

Anonymous
Not applicable
Author

Thanks for the reply.it does not show for me converting to automatically.My expression is SUM(fieldname)

Am i doing anything wrong

Thanks

Capture.PNG

Number.PNGYaxis.PNG

Anonymous
Not applicable
Author

I am able to achieve this now. had to change it to custom and change format pattern.