Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Line chart on top of stacked bar - set axis scale

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?

1 Solution

Accepted Solutions
Highlighted
Specialist II
Specialist II

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

View solution in original post

9 Replies
Highlighted
Specialist II
Specialist II

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.Capture2.PNG.png

Highlighted
MVP & Luminary
MVP & Luminary

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.

Highlighted
Not applicable

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.

Highlighted
Not applicable

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

Highlighted
Specialist II
Specialist II

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

View solution in original post

Highlighted
MVP & Luminary
MVP & Luminary

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.

Highlighted
Not applicable

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!

Highlighted
MVP & Luminary
MVP & Luminary

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.

Highlighted
Not applicable

Thank you Jagan for the explanation!