Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Fill pivot table Fromdate to Todate

Hello,

        i have a data like this with master calender.

Resource NoDateFromDateToDateREASONID
04981/9/20121/9/201211/22/2012REPAIR
25931/1/20121/1/201211/22/2012REPAIR
38161/15/20121/15/201211/22/2012REPAIR
83691/31/20121/31/201211/22/2012REPAIR
06291/12/20121/12/20129/16/2012REPAIR
20821/1/20121/1/20122/28/2013QUARANTAINE
20781/1/20121/1/201211/22/2012QUARANTAINE
20791/1/20121/1/201211/22/2012QUARANTAINE

In pivot table i want to show

Resoure No.             Mon       Tue       Wed......................   Sunday

                      Date  1/9/2012 2/9/2012  3/9/2012 ............. till 11/22/2012

0498                          Repair    Repair    Repair....................    Repair

same for all Resource Nos

Anybody thinks this is possible?

Thanks

Lavi

1 Solution

Accepted Solutions
fosuzuki
Partner
Partner

Hi Lavi,

check the attached sample...

View solution in original post

4 Replies
fosuzuki
Partner
Partner

Hi Lavi,

check the attached sample...

View solution in original post

Not applicable
Author

Thanks Fernando for your great example.

It really works for you but i don't know why it is not working in my file. Is it some strange that i don't know?

I m using the same code as you.

attached is the file.

thanks

Lavi

fosuzuki
Partner
Partner

Lavi,

try removing the following code from the ResourceLedger LOAD statement:

Date(FROMDATE) as MasterDate,

Not applicable
Author

Thanks Fernando perfectly worked.

thanks Lavi