how to create date range in qlik view? - Qlik Community

Report Inappropriate Content · ‎2017-03-07

Hi,

I have scenario

I need to create filters for selecting date range i.e

I created Vstartdate and venddate as variables and created two slider/calendar objects for selecting startdate and enddate

This will give the period between these dates

Ex:if i select Vstartdate as 2010-10-10 and enddate as 2014-10-10 then it will show the slaes between these two dates

But my requirement is 2010-10-10 8 AM to 5 Pm

2010-11-10 8 AM to 5 Pm

2010-12-10 8 AM to 5 Pm

.

2014-10-10 8 AM to 5 Pm

means daily 8am to 5pm range sales

Please do the needful

Regards

Thiru

marcus_sommer · ‎2017-03-07

It's not quite clear what do you want to do. Really including times within your range-selection and filter-logic or just additional filtering those time-ranges. For the last you could just create shifts or maybe a main-time + other times within a master-timetable and then selecting them within the UI.

- Marcus

Report Inappropriate Content · ‎2017-03-07

Hi Marcus,

It is not predefined shifts.

End user can select anything like 8am to 5pm or 4pm to 6pm like that.

So we need to provide that time filters also here as mentioned below i.e.

2010-10-10 8 AM to 5 Pm

2010-11-10 8 AM to 5 Pm

2010-12-10 8 AM to 5 Pm

.

2014-10-10 8 AM to 5 Pm

this is some time range in date wise

Regards

Thiru

marcus_sommer · ‎2017-03-07

In this case I think you will need to double your date-range-logic to an additionally time-range-logic.

- Marcus

Report Inappropriate Content · ‎2017-03-07

Hi Marcus,

I am not clear.

Please explain some more,what is double.

i need to create two set of filters?

one is for date and another is for hours?

Regards

Thiru

marcus_sommer · ‎2017-03-07

Yes, one for dates and one for the times. Theoretical you could try to implement a logic with timestamps but I'm not sure that this would be very practically.

- Marcus