Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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'))
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
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'))
Hi Ashish,
thank you for your advice.
Best regards,
Ted