topic Re: Y-Axis Dynamic Number Format in QlikView

Y-Axis Dynamic Number Format

Anonymous — Fri, 25 Apr 2014 05:33:33 GMT

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 — Fri, 25 Apr 2014 05:54:37 GMT

Like this?

jagan — Fri, 25 Apr 2014 05:58:53 GMT

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 — Fri, 25 Apr 2014 06:11:22 GMT

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

Anonymous — Fri, 25 Apr 2014 06:18:57 GMT

Hi Jagan,

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

jagan — Fri, 25 Apr 2014 07:00:25 GMT

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 — Mon, 20 Jun 2016 16:40:14 GMT

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!