Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

prma7799
Honored Contributor III

Create chart with two axis

Hi All,

How to create two axis bar chart like below.

PFA

Thanks

1 Solution

Accepted Solutions
MVP
MVP

Re: Create chart with two axis

Here you go with your two axis. If you want to see the second axis, you should

- assign your first two expression both to the left axis, third (percentage) to the right

- not customize the drawing area to be enlarged so that right axis isn't shown.

In doubt when creating a chart, start from scratch by creating a new chart, don't try to fiddle around with a chart you already have customized / modified a lot.

Seems like you implicitely have a lot of other requests, like calculating your measures or filtering the data accordingly.

I'm off for these.

18 Replies
MVP
MVP

Re: Create chart with two axis

Just go to axis tab, select the second expression and set it to position right (top).

Re: Create chart with two axis

In the properties of your chart there is a tab labeled Axes.  In this tab will be a box labeled the "Expression Axes" (similar to a Y Axis) and here you can select which Expressions you want to have on the Axes and which you don't by selecting the expression and checking or unchecking the box labeled "Hide Axis".

In the same "Axes" tab you can also specify which side of the chart you want the expression axis on in a box labeled "Position" where you can select if you want the select axis on positioned on the Left (bottom) or Right (top). 

You will probably want to hide all the axes' that you don't want to show, but that should allow you to have to unrelated line's on two seperate axes.

Highlighted
prma7799
Honored Contributor III

Re: Create chart with two axis

Hi Avinash ,

Can you please send some screen shot or some sample application for this.

Thanks

prma7799
Honored Contributor III

Re: Create chart with two axis

Hi Swuehl,

I already did this.

PFA..ff.png

MVP
MVP

Re: Create chart with two axis

I think you need to deselect 'spit axis'.

prma7799
Honored Contributor III

Re: Create chart with two axis

Growth line is going down after removing "split axis"

Re: Create chart with two axis

refer the below link which Avinash suggested

https://community.qlik.com/thread/54223

prma7799
Honored Contributor III

Re: Create chart with two axis

where i will get this option " tab labeled Axes"

prma7799
Honored Contributor III

Re: Create chart with two axis

Hi All / sunindia‌, gwassenaar‌, jagan‌, tresesco

Anyone can give some light here please..

Thanks