topic Re: Combo Chart in QlikView

Combo Chart

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi Everyone,

I am trying to create a Combo chart as per the attachment.

I have managed to do the bar part of the graph but struggling with the % line part.

The % is worked out by taking the overall total and dividing by the individual results. I would like the graph to change with each different selection.

Please could anyone advise how I would do this.

Many Thanks

Kind Regards

Wendy

Re: Combo Chart

swuehl — Wed, 25 May 2016 15:46:15 GMT

Hi Wendy,

it would be easier to answer if you actually could post the expressions and dimensions you are using, instead of a screenshot. Or even better, if you could post a small sample QVW.

In general, it should look like

=Num( Sum(Value) / Sum(TOTAL Value), '#.00%','.',',')

edit:

.. but your percentage numbers seem much too high to show part of the total

Re: Combo Chart

Anonymous — Wed, 25 May 2016 16:30:48 GMT

Hi swuehl,

Thank you for your response. That has helped me but now I am having trouble getting the Axis correct for my % part of the chart. They are not big enough and I am not sure how to increase and decrease them.

Would you be able to point me in the right direction?

Many Thanks

Kind Regards

Wendy

Re: Combo Chart

swuehl — Wed, 25 May 2016 17:01:48 GMT

You can set your percentage values to a second y-axis, go to Axes tab, select your percentage expression and select 'Position Right (Top)'.