topic How could I do a "stack chart" in Qlikview ? in QlikView

How could I do a "stack chart" in Qlikview ?

marcel_olmo — Mon, 01 Aug 2011 14:59:10 GMT

Hey guys, i'm struggling with this stuff. I'm pretty sure is quite easy, but I can't find out how could I convert this chart :

It's a sales chart witth two dimensions : hours, and month/day. I would like to merge the hour dimension with month/day in one pile, to get only a bar per hour.

How could I do that?

Many thanks in advance!!

Re: How could I do a "stack chart" in Qlikview ?

Mon, 01 Aug 2011 15:09:01 GMT

Hi Marcel, you can try creating a bar chart with the following configuration:

Dimensions: Hour, MonthDay

Expression: sum(Sales)

Then go to properties-> Style-> Subtype-> Stacked

See attached example.

Regards

Re: How could I do a "stack chart" in Qlikview ?

Mon, 01 Aug 2011 15:50:27 GMT

The main idea is that you cannot do "Stacked chart" if you have just one dimension.

How could I do a "stack chart" in Qlikview ?

marcel_olmo — Wed, 03 Aug 2011 21:55:16 GMT

Thanks Ivan, it was quite simple. As I thought.