topic Re: Stacked chart getting unstacked on adding a line in combo-chart in QlikView

Stacked chart getting unstacked on adding a line in combo-chart

Tue, 10 Jun 2014 04:21:17 GMT

Hello Group,

I have selected 'Combo-chart' as the chart type.

I want to display stacked barchart with a trend-line (calculating as runningtotal of quantity/total quantity)

Stacked barchart is displayed only when exprassion for line is diabled.

On enabling the expression for line graph, stacked chart is becoming unstacked !!!

Please advice, if I am missing something.

Re: Stacked chart getting unstacked on adding a line in combo-chart

tresB — Tue, 10 Jun 2014 04:40:02 GMT

This is how the chart behaves. If you have multiple dimensions and multiple expressions, the chart would stack the expressions. In that case you have to check 'Bar' option the the expression tab.

Re: Stacked chart getting unstacked on adding a line in combo-chart

Tue, 10 Jun 2014 04:44:36 GMT

Hi Tresesco,

Thanks for the info, Ok clear.

But, how can we achive this.

Please suggect how, can I re-design ?

Re: Stacked chart getting unstacked on adding a line in combo-chart

senpradip007 — Tue, 10 Jun 2014 04:46:36 GMT

InExpression tab look at DisplayOption region and Check Bar instead of Line.

Re: Stacked chart getting unstacked on adding a line in combo-chart

Tue, 10 Jun 2014 04:49:36 GMT

Hi Pradip,

Thanks for the reply,

The requirement is, i have to display line on stacked barchart, so I cannot set the display option to 'Bar'.

Re: Stacked chart getting unstacked on adding a line in combo-chart

tresB — Tue, 10 Jun 2014 04:54:44 GMT

I am afraid - that is not possible as of now in qv.

Update: An alternative and not eligant at all solution could be like: create mutiple expressions for all possible values of second dimension and remove the second dimnesion; present these expressions as bar to get stacked and lastly the separate expression as line.

Re: Stacked chart getting unstacked on adding a line in combo-chart

Tue, 10 Jun 2014 06:04:53 GMT

Hi Tresesco,

Thanks for the suggested work around.

It works

Re: Stacked chart getting unstacked on adding a line in combo-chart

Tue, 10 Jun 2014 06:50:46 GMT

Hi Deepa,

This is possible but you have to change the axis of 2nd or 3rd expression.

Garry

Re: Stacked chart getting unstacked on adding a line in combo-chart

Tue, 10 Jun 2014 07:08:02 GMT

Hi Gaurav,

I am looking for exactly same display as in your sample.

But, unfortunately even after I set 2 expressions axis ( 1 to Left(Bottom) and 2nd to Right(Top) ) it is still same as before.

When I enable line expression it is un-stacking .