topic Transforming from Grouped chart to Stacked does not work? in QlikView

Transforming from Grouped chart to Stacked does not work?

marko_rakar — Thu, 15 May 2014 07:22:42 GMT

I have tried to create stacked chart out of my data in order to simulate gantt chart (based on instructions by Henric Cronström.

Now, when I make my chart as grouped then it works correctly, all data points are shown in proper size and place. BUT, when I switch to stacked chart then I only see what appears to be either my first or last segment (depending on which sorting I use, or whatever is first in my data stream).

My question is why the rest of my events do not show? (and how can I fix it)

Re: Transforming from Grouped chart to Stacked does not work?

Anonymous — Thu, 15 May 2014 07:32:24 GMT

Hi,

Please find the attachment..

Its working fine.......

Re: Transforming from Grouped chart to Stacked does not work?

marko_rakar — Thu, 15 May 2014 07:38:06 GMT

this is not it,

idea is to create gantt chart, so every box (every change of campaign ID) should be in the same line, but positioned relative to the date when the campaignID starts

Re: Transforming from Grouped chart to Stacked does not work?

Peter_Cammaert — Thu, 15 May 2014 07:47:46 GMT

In the "Stacked" chart, loose the Axis->Static Min and Expressions->Bar Offset settings. I guess it's obvious that when values are stacked, you cannot offset the bars. QlikView wil position them on top of each other.

Re: Transforming from Grouped chart to Stacked does not work?

marko_rakar — Thu, 15 May 2014 07:52:37 GMT

Well I am not sure that this is quite true, there is an example shown at the article:

http://community.qlik.com/blogs/qlikviewdesignblog/2012/06/01/recipe-for-gantt-chart

And it works as I would like mine chart to work, it is just that I can not figure out what I did wrong (or missed doing entirely).

Re: Transforming from Grouped chart to Stacked does not work?

Peter_Cammaert — Thu, 15 May 2014 10:01:24 GMT

Read the article again. In the last bullet list, the next to last item says it all: "Stacked charts don't work too well with bar offsets"...

Now that I know what you are trying to accomplish, I would like to change my above suggestion into: use your Grouped graph at the top, it works best in a Gantt chart simulation.

Good luck,

Peter

Re: Re: Transforming from Grouped chart to Stacked does not work?

marko_rakar — Fri, 16 May 2014 10:14:30 GMT

Well, this is not entirely true.

Stacked charts work correctly, it is just that when you have first offset, you need to calculate position from the beginning of the chart, and all following bars have to be calculated again relative to the position of the last bar segment.

So, her is the answer to my own question with correct approach applied.

Re: Re: Re: Transforming from Grouped chart to Stacked does not work?

Peter_Cammaert — Fri, 16 May 2014 11:09:27 GMT

Well, I'm glad that I'm still not too old to learn.

Care to upload your corrected gantt problem.qvw again? Thanks.

Re: Re: Re: Transforming from Grouped chart to Stacked does not work?

Peter_Cammaert — Fri, 16 May 2014 11:10:47 GMT

Sorry, I was looking at the shortened message panel in Inbox, which doesn't show attached documents. Forget my previous reply.