topic Re: How To Setup Combo Chart? in Connectivity & Data Prep

How To Setup Combo Chart?

Mon, 30 May 2016 23:22:32 GMT

Hello,

In Qlik Sense, I drag in Combo Chart, but I'm unable to select one measure on one axis and another measure on another axis. Is there something I might have missed? Maybe a link or video on how to set this up would be much appreciated.

Thanks.

Re: How To Setup Combo Chart?

sunny_talwar — Mon, 30 May 2016 23:27:41 GMT

May be look here: Combo chart properties ‒ Qlik Sense‌

Re: How To Setup Combo Chart?

sunny_talwar — Mon, 30 May 2016 23:42:26 GMT

After further reviewing it seems that you can either take both the measure on right or left axis, but Sense doesn't allow to have two separate axis.

Re: How To Setup Combo Chart?

Tue, 31 May 2016 04:32:53 GMT

Not sure if having both discrete measures on the same axis will make any sense, unless you have a sample that shows that it does. Is this limitation only in Sense, or does QV has the same issue?

Thanks for your response.

Re: How To Setup Combo Chart?

Anonymous — Tue, 31 May 2016 14:16:56 GMT

Hi John,

Is this what you are looking for in a combo chart.

Please let me know if you want qvf file attached ..

Thanks

Chandra

Re: How To Setup Combo Chart?

Tue, 31 May 2016 14:51:35 GMT

Thanks for sharing Chandra. I see two measures in your chart, but don't see two axis or two scales to show the discrete measures. I have one for GDP and one for Population or Age, so other charting tools I've used would show them on separate axis.

Thanks.

Re: How To Setup Combo Chart?

Anonymous — Tue, 31 May 2016 15:04:07 GMT

HI John,

I don't know if you have expanded the screen shot it has 2 scales and 2 metrics Actual and Plan one is primary axis and the other is secondary axis. I am attaching another screen shot. Please ignore if I did not understand properly...

Thanks

Chandra

Re: How To Setup Combo Chart?

Tue, 31 May 2016 15:08:23 GMT

Yes. That's precisely what I'm looking for. If you have QVF or steps to accomplish it, I would appreciate it.

Re: How To Setup Combo Chart?

Anonymous — Tue, 31 May 2016 15:23:35 GMT

Hi John,

Please drag and drop the combo chart from the charts on the left hand side.

Please choose your dimension:

Next choose your two metrics from Right hand side pane and then choose how you want to represent

Line Bar or marker and immediately below choose Primary or Secondary Axis and repeat the same for the second metrics but change the representation choose marker for the second.

I have chosen actual 2015 as primary Plan 2015 as a circle for secondary:

Please see they are highlighted in Yellow on the left pane

Re: How To Setup Combo Chart?

Anonymous — Tue, 31 May 2016 15:26:24 GMT

Hi John,

Please mark the response as Correct or Helpful so that it helps other members of the community...

Thanks

chandra

Re: How To Setup Combo Chart?

Tue, 31 May 2016 16:35:41 GMT

I got it. Thanks!