topic One Date Range in QlikView

One Date Range

qlikwiz123 — Sat, 16 Nov 2024 04:33:23 GMT

I have a Date Field and I need to create a Start Date and End Date using that one Date field. Picking up the Start and End Dates should display the values in the other fields corresponding to this range. How do I do this?

Re: Start Date and End Date from one Date Field

pradosh_thakur — Tue, 05 Feb 2019 14:43:32 GMT

how does your data looks like ? provide some example.

Re: Start Date and End Date from one Date Field

qlikwiz123 — Tue, 05 Feb 2019 14:45:40 GMT

Sorry but since the data is private, can't really share any sample. But the idea is simple. Have a single date field but I need to create a Start Date and End Date from that one field to create a range. If I pick Jan 1 2018 as my Start Date and Mar 30 2018 as my End Date, it should select all the days in between in that one Date field.

Re: Start Date and End Date from one Date Field

qlikwiz123 — Tue, 05 Feb 2019 15:12:44 GMT

@pradosh_thakur @sunny_talwar

Any thoughts on this one is really appreciated folks 🙂

Re: Start Date and End Date from one Date Field

sunny_talwar — Tue, 05 Feb 2019 15:15:21 GMT

Try this

Re: Start Date and End Date from one Date Field

qlikwiz123 — Fri, 08 Feb 2019 16:11:36 GMT

Good solution Sunny. But one issue here is, in the End Date, I also see dates before the Start Date Value too, as in if Start Date is Jan 2002, End Date shows dates beyond 2002 year as well. How to make the End Date only show date values that appear after Start Date value?

In EndDate calendar, I changed min to =Min({1}vStartDate) and max to Max({1}Date). This shows future dates that are not present in the Date field.

@sunny_talwar

Re: Start Date and End Date from one Date Field

sunny_talwar — Fri, 08 Feb 2019 16:19:26 GMT

Please share a sample so that we can see the issue.

Re: Start Date and End Date from one Date Field

qlikwiz123 — Fri, 08 Feb 2019 16:35:49 GMT

PFA

Re: Start Date and End Date from one Date Field

sunny_talwar — Fri, 08 Feb 2019 16:47:01 GMT

May be try the attached

Re: Start Date and End Date from one Date Field

qlikwiz123 — Fri, 08 Feb 2019 16:53:25 GMT

Thank you so much.