Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
macaulay
Contributor

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

Tags (3)
3 Replies
shraddha_g
Honored Contributor III

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

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

MVP
MVP

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

See here

Number formatting based on the condition

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
macaulay
Contributor

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

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