Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Not applicable

Taking a field Creating an additional entry

Hi

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

1 Reply
Highlighted
Not applicable

Re: Taking a field Creating an additional entry

I found this does the trick

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

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