topic Re: Gantt (Pivot Table) with multiple values for a dimension in QlikView

Gantt (Pivot Table) with multiple values for a dimension

belromvar — Thu, 14 Dec 2017 10:37:16 GMT

Hi,

Is there a way to create a gantt diagram with more than one value for each dimension?

My data looks like:

ID	Type	Subtype	From	To
A	A1	A11	01.01.2018	13.01.2018
A	A1	A12	05.01.2018	10.01.2018
A	A2	A21	15.12.2017	15.01.2018
A	A3	A31	03.11.2017	18.12.2017
A	B4	B11	24.11.2017	25.11.2017
...	...	...	...	...

In my chart I want to show the ID, the type and the calendar info. I followed this example: How to create a Gantt chart using a Pivot table, however it only works for one value per dimension (A1 will not be shown, since it is the aggregation of A11 and A12 subtypes).

My goal:

What I have:

I appreciate any ideas or suggestions?

Re: Gantt (Pivot Table) with multiple values for a dimension

sunny_talwar — Thu, 14 Dec 2017 13:17:18 GMT

What is the expression that you use?

Re: Gantt (Pivot Table) with multiple values for a dimension

belromvar — Thu, 14 Dec 2017 13:31:17 GMT

I forgot to mention I am using a MasterCalendar. The dimensions are ID, Type, Year, Month, Day. The expression is:

=if([Zeitraum Von]=[Zeitraum Bis],'⚡',

if(date(ReferenceDate)=date(Today()),'T',

if([Zeitraum Von] = ReferenceDate,'⚐',

if([Zeitraum Bis] = ReferenceDate,'⚑',

if([Zeitraum Bis]-ReferenceDate+1>0,'⚊')))))

Re: Gantt (Pivot Table) with multiple values for a dimension

sunny_talwar — Thu, 14 Dec 2017 13:35:15 GMT

What is reference date here?

Re: Gantt (Pivot Table) with multiple values for a dimension

belromvar — Thu, 14 Dec 2017 13:41:52 GMT

ReferenceDate was defined in the MasterCalendar, it´s a date i.e. 2017.12.04

Re: Gantt (Pivot Table) with multiple values for a dimension

sunny_talwar — Thu, 14 Dec 2017 13:49:05 GMT

Are you doing an interval match between your data and master calendar?

Re: Gantt (Pivot Table) with multiple values for a dimension

belromvar — Thu, 14 Dec 2017 14:49:45 GMT

No, I have an Events_Dates table:

Events_x_Dates:

Load ID, Type, Subtype, Date(From + IterNo()-1) as ReferenceDate

Resident Events

While IterNo() <= To - From + 1 ;