topic Re: Create chart with two axis in QlikView

Create chart with two axis

prma7799 — Wed, 14 Oct 2015 10:39:25 GMT

Hi All,

How to create two axis bar chart like below.

PFA

Thanks

Re: Create chart with two axis

swuehl — Wed, 14 Oct 2015 10:42:31 GMT

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

Re: Create chart with two axis

avinashelite — Wed, 14 Oct 2015 10:44:22 GMT

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.

Re: Create chart with two axis

prma7799 — Wed, 14 Oct 2015 10:55:46 GMT

Hi Avinash ,

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

Thanks

Re: Create chart with two axis

prma7799 — Wed, 14 Oct 2015 10:57:04 GMT

Hi Swuehl,

I already did this.

PFA..

Re: Create chart with two axis

swuehl — Wed, 14 Oct 2015 10:59:49 GMT

I think you need to deselect 'spit axis'.

Re: Create chart with two axis

prma7799 — Wed, 14 Oct 2015 11:03:37 GMT

Growth line is going down after removing "split axis"

Re: Create chart with two axis

Kushal_Chawda — Wed, 14 Oct 2015 11:04:07 GMT

refer the below link which Avinash suggested

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

Re: Create chart with two axis

prma7799 — Wed, 14 Oct 2015 11:10:24 GMT

where i will get this option " tab labeled Axes"

Re: Create chart with two axis

prma7799 — Wed, 14 Oct 2015 11:25:51 GMT

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

Anyone can give some light here please..

Thanks

Re: Create chart with two axis

prma7799 — Wed, 14 Oct 2015 12:42:37 GMT

Re: Create chart with two axis

avinashelite — Wed, 14 Oct 2015 12:46:03 GMT

with this key word , as per my knowledge we don't have i guess. Are you looking for the Dimension labels(in Dimension tab) or Expression Lables(in expression tab)

Re: Create chart with two axis

swuehl — Wed, 14 Oct 2015 12:52:53 GMT

Avinash R wrote:

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".

I think you are looking for the chart properties tab labelled 'Axes'. But I don't know what to add to above posts.

In general, what you are trying to do should be done using the options you already discovered looking at your screenshot, maybe just with different combinations.

To tell you more, please post a small sample QVW.

Re: Create chart with two axis

qlikviewwizard — Wed, 14 Oct 2015 12:57:42 GMT

hi check this.

Re: Create chart with two axis

Wed, 14 Oct 2015 13:12:56 GMT

can you post the qvw in question - I believe with the screen sample you provided along with the applciation, it will be better understood what you are looking for or what the problem is.

Typically all you should have to do, as was stated earlier is to select bottom right for the other expression, and do not believe you need to select split axis

Re: Create chart with two axis

Wed, 14 Oct 2015 13:15:46 GMT

I made a slight modification to the chart to showm how it would look with a bar and a line on a combo chart with the 2 different axis

Re: Create chart with two axis

prma7799 — Thu, 15 Oct 2015 03:33:25 GMT

Hi Adam,

Thanks for your help but still i am not getting my requirement.

PFA in that i want growth from right side axis as mention in attachment.

growth is ((TY-PY)/PY)*100

Thanks...

Re: Create chart with two axis

prma7799 — Thu, 15 Oct 2015 04:00:54 GMT

Dear All,

I want values on X-axis and Growth on Y-axis with two years data.

Thanks

Re: Create chart with two axis

swuehl — Thu, 15 Oct 2015 09:51:16 GMT

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.