topic Re: Pivot like GANNT in QlikView

Pivot like GANNT

gamaplast — Sat, 02 Jul 2016 09:23:30 GMT

Hi guys,

I need to rapresent my data in a pivot table, like a Gannt rapresentation; in my DB the records have these 3 fields:

- Machine

- StartWorkingDay

- EndWorkingDay

I thing that the best way to get my porpouse is to trasform my data multiplying them as this example:

Machine StartWorkingDay EndWorkingDay

A 01/07/16 05/07/16

Machine WorkingDay

A 01/07/16

A 02/07/16

A 03/07/16

A 04/07/16

A 05/07/16

Is there a Qv way to do it?

Is there a better idea to reach my goal?

Thanks.

sunny_talwar — Sat, 02 Jul 2016 11:22:45 GMT

Try this:

Table:

LOAD Machine,

Date(StartWorkingDay + IterNo() - 1) as WorkingDay

While StartWorkingDay + IterNo() - 1 <= EndWorkingDay;

LOAD * Inline [

Machine, StartWorkingDay, EndWorkingDay

A, 01/07/16, 05/07/16

];

gamaplast — Sat, 23 Jul 2016 07:18:05 GMT

...Sorry for the delay, but I've gone away for my Summer Holidays 🙂

Your solution works so fine!! Thank you so much for your help. 🙂

sunny_talwar — Sat, 23 Jul 2016 15:30:48 GMT

No problem at all