topic Re: single stack chart with normal bar chart in QlikView

single stack chart with normal bar chart

Thu, 05 Dec 2013 14:25:48 GMT

Hi ,

I have requirement where I need to represent current , prior year, budget and Actual values in a bar chart which should come in one stack bar with half colored with current year and prior year with in the same stack bar and other bar would be in normal view in Grouped bar chart.

For further clarification I have attached the image .Please provide solution ASAP

Thank you.

Re: single stack chart with normal bar chart

MK_QSL — Thu, 05 Dec 2013 14:58:22 GMT

it would be better if you could upload your data...

Re: single stack chart with normal bar chart

datanibbler — Thu, 05 Dec 2013 15:09:48 GMT

Hi Manoj,

if I understand you correctly, then you want to have some values stacked - and other values as separate columns in that chart?

Unfortunately, that is not possible in QlikView afaIk - either you have a stacked bar_chart - but then QlikView stacks everything - or you have another type of chart and QlikView does not stack anything.

It is possible to have QlikView stack some values in a combo_chart and have lines in the same chart, but I don't know of any way to have QlikView stack only part of the values you have.

HTH

Best regards,

DataNibbler