topic Re: Stacked bars problem in QlikView

Stacked bars problem

Wed, 21 Jan 2015 09:48:42 GMT

Hi!

I have a problem with stacked bars. I am trying to create a Gantt chart of project phases based on this instruction: http://community.qlik.com/docs/DOC-3113. As you can see in the picture, the chart works ok in grouped but when I try to stack the bars only the green one is showing and the others disappear. Is it because the 'Delivery Month' doesn't have an end date and therefore zero values exist? Or could there be other reason for the disappearance? The end date is created of the 'Date' of next phase and the last phase doesn't have anything to create the end date from. Any idea how to fix the problem or do the chart using other methods?

Thanks for your help!

Regards,

Heidi

Re: Stacked bars problem

sat_tok52 — Wed, 21 Jan 2015 10:35:42 GMT

Hi HeidiKor,

Don't Do Stacked use Grouped, because to create a stacked bar need at least two dimension.

-Sateesh Tokala

Re: Stacked bars problem

Wed, 21 Jan 2015 11:00:25 GMT

I have two dimensions. Project phases and Project name, the example chart only has one project as an example.

Re: Stacked bars problem

sat_tok52 — Wed, 21 Jan 2015 11:34:33 GMT

Have you used Bar offset in your chart?

Re: Stacked bars problem

Wed, 21 Jan 2015 11:37:44 GMT

Yes it is min(Date) for the only expression I have.