topic Re: Stacked Bar Chart in QlikView

Stacked Bar Chart

Thu, 11 Sep 2014 08:27:49 GMT

Hi,

Is it possible to create a stacked bar chart in combo chart having two expressions?

Thanks

Re: Stacked Bar Chart

MK_QSL — Thu, 11 Sep 2014 08:32:23 GMT

When you create a combo chart, the 2nd expression will automatically pick Line...

Go to your second expression and untick line and tick bar

now go to style tab and select stacked ...

Re: Stacked Bar Chart

amit_saini — Thu, 11 Sep 2014 08:34:22 GMT

Asma ,

Follow this:

Is it possible to make stacked bar chart in Combo Chart?

Thanks

Re: Stacked Bar Chart

sujeetsingh — Thu, 11 Sep 2014 08:37:56 GMT

Yes of course

Re: Stacked Bar Chart

ogster1974 — Thu, 11 Sep 2014 08:40:11 GMT

Yes you can see attached.

Re: Stacked Bar Chart

Thu, 11 Sep 2014 09:59:00 GMT

I have created three expressions. The first two with the bar and the third one as line. But then when i go to the style option, the stacked bar option is disabled.

I want a chart e.g. Say Month vs three measures: SUM(Field) according to FieldA, Sum(Field) according to FieldB, Sum(Field).

The first two measures mentioned above should be displayed as bars wheras the third measure should be a line chart.

Thanks

Re: Stacked Bar Chart

ogster1974 — Thu, 11 Sep 2014 10:36:32 GMT

try using set analysis to identify to different fields to filter or Agr() if its group by the fieldA,B you want. When doing this the Staked style wasn't greyed out for me.

Re: Stacked Bar Chart

Thu, 11 Sep 2014 10:50:23 GMT

Thanks a lot!!!

Re: Stacked Bar Chart

ogster1974 — Thu, 11 Sep 2014 11:09:17 GMT

No problem. Please mark as correct the appropriate comment if I have answered your question.

Regards

Andy