topic Re: how to create date range in qlik view? in QlikView

how to create date range in qlik view?

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: how to create date range in qlik view?

marcus_sommer — Tue, 07 Mar 2017 07:54:11 GMT

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

Re: how to create date range in qlik view?

Tue, 07 Mar 2017 08:01:19 GMT

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

Re: how to create date range in qlik view?

marcus_sommer — Tue, 07 Mar 2017 08:11:16 GMT

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

- Marcus

Re: how to create date range in qlik view?

Tue, 07 Mar 2017 08:14:41 GMT

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

Re: how to create date range in qlik view?

marcus_sommer — Tue, 07 Mar 2017 08:23:03 GMT

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