Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

belromvar
New Contributor II

Gantt (Pivot Table) with multiple values for a dimension

Hi,

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

My data looks like:

IDTypeSubtypeFromTo
AA1A1101.01.201813.01.2018
AA1A1205.01.201810.01.2018
AA2A2115.12.201715.01.2018
AA3A3103.11.201718.12.2017
AB4B1124.11.201725.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:

goal.PNG

What I have:

Gantt.PNG

I appreciate any ideas or suggestions?

6 Replies

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

What is the expression that you use?

belromvar
New Contributor II

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

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

What is reference date here?

belromvar
New Contributor II

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

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

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

belromvar
New Contributor II

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

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 ;

Community Browser