topic Re: Transform data in QlikView

Transform data

Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Transform data

kaushiknsolanki — Tue, 20 Dec 2016 10:21:56 GMT

Hi,

For your scenario you should use the interval match function.

Regards,

Kaushik Solanki

Re: Transform data

Tue, 20 Dec 2016 10:24:54 GMT

Hi Kaushik,

Not sure how to go about this

Thanks

Re: Transform data

kaushiknsolanki — Tue, 20 Dec 2016 10:26:30 GMT

Hi,

Have a look at the link below for more help.

IntervalMatch

Interval Match Feature/Function

Regards,

Kaushik Solanki

Re: Transform data

qlik_jaijhn — Tue, 20 Dec 2016 11:01:16 GMT

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

Re: Transform data

Tue, 20 Dec 2016 11:30:27 GMT

Thank you John, this answers my question.