topic Line chart on top of stacked bar - set axis scale in QlikView

Line chart on top of stacked bar - set axis scale

Tue, 28 Oct 2014 01:42:00 GMT

Hi everyone,

I am trying to overlay a line chart on a stacked bar chart. How can I ensure that no matter what the current selection is, the two charts will have the same axis scale?

Re: Line chart on top of stacked bar - set axis scale

danieloberbilli — Tue, 28 Oct 2014 02:31:39 GMT

In Chart properties, set the static min and max for the y-axis.

Take care that the x-axis works simultaneously e.g. on the Dimension tab: check (or uncheck) Suppress When Value is Null.

Re: Line chart on top of stacked bar - set axis scale

jagan — Tue, 28 Oct 2014 02:44:09 GMT

Hi,

Try like this

Chart Properties-> Axes -> Specify the values for Static Min, Static Max and Static Step values.

Hope this helps you.

Regards,

Jagan.

Re: Line chart on top of stacked bar - set axis scale

Tue, 28 Oct 2014 14:32:28 GMT

Thanks for your responses.

The problem is, I want the axes to be able to adjust for different selections. If I set static min and max, some selections will look very small. I just want the two graphs to have linked axes so they match up perfectly - right now, they will match for one selection, but in the next selection the max values will have very different heights.

Re: Line chart on top of stacked bar - set axis scale

Tue, 28 Oct 2014 14:33:36 GMT

Is there a way to write expressions for the static min/max/step of one graph to equal the other graph?

Re: Line chart on top of stacked bar - set axis scale

danieloberbilli — Tue, 28 Oct 2014 22:02:46 GMT

yes whatever suits: e.g. axis: max( [expr] ) - to make sure the extreme ends are the same

Re: Line chart on top of stacked bar - set axis scale

jagan — Wed, 29 Oct 2014 01:42:58 GMT

Hi,

You can give the same expression to the charts then the values are same in both the charts, the expressions may be something like this

Max(SomeDimension)

Min(SomeDimension)

etc.

Regards,

Jagan.

Re: Line chart on top of stacked bar - set axis scale

Wed, 29 Oct 2014 21:53:20 GMT

Hi guys,

Thank you so much. It seems to be working, but for some reason, it says there is an error in expression. Could you take a quick look at this expression and say why? In the chart Axis tab, I checked 'Static Max', and I put for expression:

=max(sum({<[Project Name]-={'Apples'}>}Amounts))

The { before Apples was underlined red. I don't know why.

Thanks!

Re: Line chart on top of stacked bar - set axis scale

jagan — Thu, 30 Oct 2014 01:47:30 GMT

Hi,

when you -= in set analysis it will show as syntax error but it works it is a bug in qlikview, you can ignore that.

Regards,

Jagan.

Re: Line chart on top of stacked bar - set axis scale

Thu, 30 Oct 2014 14:18:37 GMT

Thank you Jagan for the explanation!