topic Re: Fetch data between selected dates in QlikView

Fetch data between selected dates

Anonymous — Thu, 04 Jan 2018 09:36:40 GMT

I have a leave management application where user apply leave from and to date. e.g. 12/1/18 to 19/1/18. Now i wish to add calendar control (day field) which would reflect this record if any value selected between 12 to 19 like 13,15 etc.

Currently i added from date and to date controls which doesn't reflect the record if select 13,15.

Thanks

Re: Fetch data between selected dates

tresB — Thu, 04 Jan 2018 09:39:17 GMT

Check the video here:Selecting Arbitrary Date Ranges

Re: Fetch data between selected dates

Anil_Babu_Samineni — Thu, 04 Jan 2018 09:40:36 GMT

Please start google -- Date Arbitrary is the solution

Re: Fetch data between selected dates

mdmukramali — Thu, 04 Jan 2018 09:40:59 GMT

Hi,

You have to Generate all the Missing dates by using Master Calendar :

Suppose you have Leave Start date and EndDate e.g. 12/1/18 to 19/1/18.

there is no record available for that employee in the System for 13,15.

for that, you have to generate the calendar for each day and need to check the status of the all the employees.

can you share sample data file?

Thanks,
Mukram.

Re: Fetch data between selected dates

Anonymous — Fri, 05 Jan 2018 06:46:56 GMT

Not solving the problem. In my data i don't have any record (line) with date 13 or 15 like in your example you have all dates in the field order date.

Re: Fetch data between selected dates

Anonymous — Fri, 05 Jan 2018 07:10:47 GMT

Want to avoid generating those rows which are considered on between dates (i don't know how ). Attached is the sample data file and app.

Here date 20.12 is between leave 18-22 for employeeID 60. So if i select 20.12 in calendar... it should also show this record.

Thanks.