topic Combo chart plotting $'s / % of total in QlikView

Combo chart plotting $'s / % of total

zagzebski — Tue, 24 Nov 2015 22:16:13 GMT

I need to do a Combo chart. Basically I want the bar to be "Amount" field and I want to line graph to plot the "Pct of Total". I know having two expressions won't work and not sure how I have dollars for the bar chart and % for the line graph.

AR	Amount	Pct of Total
0-30	1000	48%
30-60	700	33%
60-90	300	14%
90+	100	5%

Thanks in advance,

Zag

Re: Combo chart plotting $'s / % of total

Anonymous — Tue, 24 Nov 2015 22:26:00 GMT

On the Axes tab of your Combo Chart for each expression you can set its position, so position one left and the other right and it will ok for one to be in $ and the other %

Re: Combo chart plotting $'s / % of total

zagzebski — Mon, 30 Nov 2015 00:55:03 GMT

Thanks Bill.