How to show chart y-axis like Millions and Thousandas?

[#1]

Hi ,

please find the below attached file

How to Display Y-AXIS lik this

1 K

2 K

3 K

4 M

please help me

Thanks

[Anonymous]

Hi,

Please find below snapshot.

[#3]

i tried but not working

in the chart both millions and thousands will display.

[#4]

i tried but not working

in the chart both millions and thousands will display.

[stevedark]

To make this function correctly you need to enter K, M and B into the Thousand, Million and Billion boxes respectively.  The symbol field is for putting a unit of measure in, for instance you may go for $, $K, $M and $B into into each of the boxes.

Hope that helps,

Steve

[greg-anderson]

Kristamma, Qlikview does not have the dynamic multiple assignment you're seeking.  Using the built-in symbols will allow you to format an axis as thousands, millions, or billions, but it will always use a consistent unit for the entire axis.  In your example above, it would show $500k as $0.5M.  Or you could shift everything to thousands, but that would be more confusing.

Many graphing products work in a similar manner.  Consistency helps to avoid confusion.

Sorry.  Hope it helps!