Taking a field Creating an additional entry

Fri, 26 Jun 2015 14:51:27 GMT

Not sure I can explain this too well but here goes.

I have a Table that contains Diary Entries - I would like to create an entry for each day so I can add into a Calendar view.

Example of data below

ID Trans_No Start_Date_Time End_Date_Time Code User_Name

1 12 01/01/2015 00:00:00 04/01/2015 17:00 Leave Bob

2 13 01/01/2015 00:00:00 01/01/2015 17:00 Leave Jim

I would like Qlikview to create a line for each day eg ID 1 - Create an additional entry for the 2nd/3rd/4th for Bob but ID2 no need to create any additional data.

I am not worried about the time element at this point.

Can anyone give me an easy guide or example to show how to do this.

Many Thanks

Dave

Re: Taking a field Creating an additional entry

Fri, 26 Jun 2015 15:10:17 GMT

I found this does the trick

LOAD *, date([START_DATETIME] + IterNo() -1) as Date

while [START_DATETIME] + IterNo() -1 <= [END_DATETIME];

topic Taking a field Creating an additional entry in QlikView

Taking a field Creating an additional entry

Re: Taking a field Creating an additional entry