Y-Axis Dynamic Number Format

[Anonymous]

Hi,

Can some one advice me how to control number on Y-Axis.

I have attached sample file here and When i select option "Actual" then Y Axis suppose to show orginal number.

1. When i select option "Actual" then Y Axis suppose to show orginal number.

2. When i select option "Million" then Y Axis suppose to show in Millions but when i move cursor onto BAR then it suppose to acual number.

See in my 2nd chart and advice how to do that.

.

[MK_QSL]

Like this?

[jagan · Accepted solution]

Hi,

Try like this

Create a variable

vOption =If(Option = 'Actual',  1,

  If(Option = 'Millions', 1000000,

  If(Option = 'Billions', 1000000000,

  If(Option = 'Thousands', 1000,1))))

Now in expression : Sum(Sales) / vOption

Hope this helps you.

Regards,

Jagan.

[Anonymous]

Thanks Jagan This works, Can't we control from Number TAB?

[Anonymous]

Hi Jagan,

On BAR it is showing number in both format but i would like to show only actual number.

[jagan]

Hi,

Tried to show only selected format, but not possible.  If we try in Number tab, it is always showing in Millions.

Regards,

Jagan.

[Anonymous]

Hi,Jaswant, do you mean you can dynamic show y axis range?

I tried your qvw file, but still feel lost.

Could you also create a Qlik sheet with your sample file?

Thanks!