Transform data

[#1]

hello,

I have data in the format below. So what I want to achieve is the situation where if for example the No_of_Leave_days 3  i.e Unique_Id = 4793870, then based on the Calendar I created then 12 days taken should be split for each day.

LeaveStartDate =4/28/2016 and LeaveEndDate = 4/30/2016, then I want to see

4/28/2016          4/29/2016       4/30/2016

      1                        1                  1

There are some days when leave was reversed (Reversal field) . Not sure if I have explained my well.

[kaushiknsolanki]

Hi,

For your scenario you should use the interval match function.

Regards,

Kaushik Solanki

[#3]

Hi Kaushik,

Not sure how to go about this

Thanks

[kaushiknsolanki]

Hi,

Have a look at the link below for more help.

IntervalMatch

Interval Match Feature/Function

Regards,

Kaushik Solanki

[qlik_jaijhn · Accepted solution]

I don't think I understand your question. Please see the attached QVW to see if this is the requirement.

[#6]

Thank you John, this answers my question.