One Date Range

[qlikwiz123]

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?

[pradosh_thakur]

how does your data looks like ? provide some example.

[qlikwiz123]

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.

[qlikwiz123]

@pradosh_thakur@sunny_talwar

Any thoughts on this one is really appreciated folks 🙂

[sunny_talwar · Accepted solution]

Try this

[qlikwiz123]

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

[sunny_talwar]

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

[qlikwiz123]

PFA

[sunny_talwar]

May be try the attached

[qlikwiz123]

Thank you so much.