Skip to main content
Announcements
Save $600 on Qlik Connect registration! Sign up by Dec. 6 to get an extra $100 off with code CYBERSAVE: REGISTER
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.