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

[Anonymous]

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

[shraddha_g]

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]

See here

Number formatting based on the condition

[Anonymous]

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