Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Illustration of values, that can be very big but also small

Dear all,

I got one question regarding the illustration of values. I got a KPI that shows how much payment we got. As it may measure a long but also a short period, the values are very different and reach from 100.000.000€ to 1.000€. My intention is to illustrate the values different. When the value of the KPI is about 100.500.000€ I would like to illustrate it as 100,5M €, as it is about 1.000€ it shall also be illustrated as 1.000€. Is it possible the do it like this in QLIK Sense?

As it is always easier to see an example I added two shots of what it looks like now.

Thanks for your advice,

Regards

Tom

3 Replies
shraddha_g
Partner - Master III
Partner - Master III

Can you share a sample app with sample data?

Normally it works when you keep Number Format as 'Auto'.

If it is still not working then you can try sharing sample app

jonathandienst
Partner - Champion III
Partner - Champion III

See here

Number formatting based on the condition

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Anonymous
Not applicable
Author

Thank you for the link, I think one of these clues will do it.