topic Re: Two dimensions in one bar chart in Management & Governance

Two dimensions in one bar chart

Anonymous — Thu, 02 Jul 2015 10:25:07 GMT

Hi All,

I am using two measures for my graph,

Can we put two separate dimensions in one bar chart so that both measures can be seen on different axis.

screen shot attached for reference.

Thanks in advance

Re: Two dimensions in one bar chart

Gysbert_Wassenaar — Thu, 02 Jul 2015 10:36:52 GMT

A bar chart can have either two dimensions and one measure or it can have one dimension and as many measures as you like. Only one dimension will be shown on the x-axis.

Re: Two dimensions in one bar chart

Anonymous — Thu, 02 Jul 2015 12:48:19 GMT

Thanks Gysbert,

i am using two measures and one dimension for my graph ( as can be seen in the attached screen shot )

but now i want two separate y axis for measures so that my data can be visualize in a standard format.

Kindly assist

Re: Two dimensions in one bar chart

jonathandienst — Thu, 02 Jul 2015 12:51:53 GMT

Go to the Sheet Properties | Axes tab, select the expression that you want to move to the RHS axis, and select Right(Top) in the Position box

Re: Two dimensions in one bar chart

Gysbert_Wassenaar — Thu, 02 Jul 2015 12:54:15 GMT

That you're using two measures and one dimension cannot be determined from your screenshot. Since you're using two measures you can choose for each measure if you want to display it on the primary or secondary axis.

Re: Two dimensions in one bar chart

perla_chirag — Thu, 02 Jul 2015 12:56:27 GMT

Hi Gaurav,

This thread will be helpful to you:

The only two y-axis chart

Re: Two dimensions in one bar chart

Anonymous — Thu, 02 Jul 2015 13:14:38 GMT

Hi Jonathan,

Thanks for the response,

ya i got it now using the option to choose axis.

but this option can be done in only if my one measures is a line graph.

if both measure represents the bar charts . this option is not showing in the properties panel.

Re: Two dimensions in one bar chart

Anonymous — Fri, 03 Jul 2015 13:04:43 GMT

Hi Chirag,

The link gives the solution for qlikview.

i need the same for qliksense