Discussion board where members can get started with QlikView.
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.
I found this does the trick
LOAD *, date([START_DATETIME] + IterNo() -1) as Date
while [START_DATETIME] + IterNo() -1 <= [END_DATETIME];