How to Showing Thousands in Qsense?

[#1]

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

[Anonymous]

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

[#3 · Accepted solution]

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'))

[#4]

Hi Ashish,

thank you for your advice.

Best regards,

Ted