topic Re: Creating Stack Chart in QV in QlikView

Creating Stack Chart in QV

Wed, 30 Mar 2016 21:11:55 GMT

Hello,

I am looking to creating a stacked bar chart in the attached format. In my attached example, values for Q1, Q2, Q3, and Q4 are calculated.

Thank You in advance!!

settu_periasamy — Thu, 31 Mar 2016 06:20:01 GMT

Hi,

You just need to load your data with CrossTable, then create the Bart chart

Dimension : Quarter and Category

Expression : Sum(Data)

Goto style tab -> check the Stacked option.

That's it.

Check the Attachment..

Anonymous — Thu, 31 Mar 2016 06:43:00 GMT

create bar chart with dim category and expression will be

1)sum(Q1)

2)sum(Q2)

3)sum(Q3)

4)sum(Q4)

on expression tab keep values on data point check box on values on data point .

on presentation tab keep values inside segment check box on.

on style tab make subtype as stacked.

thats it...

Thu, 31 Mar 2016 11:32:10 GMT

Thanks much for your help!