topic Constant Y- Axes Value in QlikView

Constant Y- Axes Value

Tue, 17 Jun 2014 13:26:37 GMT

Hi,

I am trying to create two graphs which compares the data for two entities. However the Y- axes value changes depending on the respective graph values. I want to keep the Y - axes value constant to make comparison easy.

Any suggestions.

Regards,

Re: Constant Y- Axes Value

Tue, 17 Jun 2014 13:30:04 GMT

Chart Properties -> Axes -> Scale

You can set the min, max, and step there

Re: Constant Y- Axes Value

Tue, 17 Jun 2014 13:36:07 GMT

Hi Robert,

Thanks for the response.

Yes this is one way of doing it, however this will not resolve my issue as there are different filters and when selectec values can vary from 0 - 30,000,000. So i am trying to set variable. for both graphs.

Regards,

Re: Constant Y- Axes Value

Tue, 17 Jun 2014 13:38:30 GMT

Well then you'll have to use an expression to dynamically change those bounds as selections are made.

Could you share a sample qvw?

Re: Constant Y- Axes Value

Tue, 17 Jun 2014 14:01:04 GMT

I am attaching a sample QWD where i am comparing marks from two subjects for the school. Here one graphs which has higher marks showing Y-Axes as 1000 and other as 600. I would like to make the Y-Axes as 1000 for both graphs.

Hope this helps.

Thank you for helping me.

Regards,

Re: Re: Constant Y- Axes Value

Tue, 17 Jun 2014 14:13:20 GMT

Check out my attached demo, I added in two variables and used one of the variables as the max limit for the axes on both charts

Re: Constant Y- Axes Value

Tue, 17 Jun 2014 14:18:30 GMT

Thanks Robert.