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

How to Showing Thousands in Qsense?

Hi All,

I wanna show the values in Text at Qsense in Millions even when the values goes to the Thousands, like for "500.000". i want to show it as "500 K".

i have tried ==> Num(MyExpression/1000, '#,##0.##K') in Expression, but is not working,

and if i use custom formatting, and  format pattern = '#.##0K' , if the data is null,it will show '0K', i wanna it still show '0'.

can any one help me to achieve this.

Best Regards,

Ted

1 Solution

Accepted Solutions
Not applicable
Author

Your expression works fine for me.

for not showing 'k' if value is zero we can use condition.

i have used this expression

Num(Expression/1000, if(Expression <> 0,'#,##0.##K'))

View solution in original post

3 Replies
Anonymous
Not applicable
Author

Hi,

By default Qliksense has the feature of formatting options into thousands and millions.

Just set the number formatting as Auto it will change accordingly

Not applicable
Author

Your expression works fine for me.

for not showing 'k' if value is zero we can use condition.

i have used this expression

Num(Expression/1000, if(Expression <> 0,'#,##0.##K'))

Not applicable
Author

Hi Ashish,

thank you for your advice.

Best regards,

Ted