topic Re: create stack and group bars in a same graph in QlikView

create stack and group bars in a same graph

Thu, 03 Jul 2014 17:56:45 GMT

hi all

i would like create actual and projection in group ,whereas stack bar needs to be used for Allocation

Re: create stack and group bars in a same graph

Gysbert_Wassenaar — Fri, 04 Jul 2014 08:59:03 GMT

Yes, add two dimensions to your chart and select the option Stacked on the Style tab. You will get groups of stacked bars in your chart. If you want Allocation stacked then make it the second dimension in the chart.

Re: create stack and group bars in a same graph

Fri, 04 Jul 2014 09:08:42 GMT

Hi, by using below macro you can maintain both stacked an group style in single graph.

Sub ToggleChartBarStack

dim chart

dim cp

set chart = ActiveDocument.GetSheetObject("CH29")

set cp = chart.GetProperties

If cp.ChartProperties.BarModeStacked = true then

cp.ChartProperties.BarModeStacked = false

else

cp.ChartProperties.BarModeStacked = true

end if

chart.SetProperties cp

end sub

Re: create stack and group bars in a same graph

rohan_mulay — Fri, 04 Jul 2014 09:54:04 GMT

Hi Jayanthan,

Add 2 dimensions in a bar chart and 2 expressions and select Stacked style.

I have following data:

City,Population,Month

Mumbai,20,Jan

Pune,40,Jan

Mumbai,35,Feb

Goa,31,Jan

Mumbai,60,Mar

Pune,25,Feb

Pune,56,Apr

Goa,31,Feb

Goa,31,Apr

Add City and Month field in dimension and specify 2 expressions for the data. Here I have used following expressions:

=sum(Population+68)

=(sum(Population))

This gives following output where for City Goa we get Group of bars specifing Months and representing the values for both of the above expressions

Re: create stack and group bars in a same graph

Anonymous — Fri, 04 Jul 2014 10:03:26 GMT

Hi,

Look into attached file.

Re: create stack and group bars in a same graph

Fri, 04 Jul 2014 10:05:01 GMT

thank you all.

Sorry, i have miscommunicated earlier. I want Actual and Projection in Stack ,whereas allocation as another bar(since i do not how to have stack and group in a same chart, i have put allocation in line chart). {

Please refer the below screen shot

Re: Re: create stack and group bars in a same graph

Wed, 09 Jul 2014 09:56:58 GMT

hi satya

it doesnt work for me. Kindly help to solve this issue

please refer the attached QVW

Re: Re: Re: create stack and group bars in a same graph

Anonymous — Wed, 09 Jul 2014 10:14:17 GMT

See attachment

Re: create stack and group bars in a same graph

Wed, 09 Jul 2014 10:33:59 GMT

superb Satya

thank you .

Can i know where i went wrong

Jayanthan

Re: create stack and group bars in a same graph

Anonymous — Wed, 09 Jul 2014 13:14:25 GMT

Hi Jayanthan,

You need to add "TypeID" in dimension of your chart and adjust expression with "Type" so that it will group in "Budget" and "Projection & Sales" category.

Thanks

Re: create stack and group bars in a same graph

szeconku — Wed, 10 Jan 2018 14:06:32 GMT

Where/How would you apply the macro? In the sheet?

Re: create stack and group bars in a same graph

Shubham_Deshmukh — Thu, 04 Jul 2019 11:29:18 GMT

But hw can I do this in QlikSense, we cannot take more than 1 measure if we take 2 dimensions in Qliksense.

Shubham

Re: create stack and group bars in a same graph

ashima_0605 — Thu, 16 Jul 2020 09:54:50 GMT

Hi,

Is it possible to do the same in Combo Chart in QLIK Sense Feb 2020 version?

Because I have to create a stack bar, normal and a line chart to show month-wise data.