Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
qlikwiz123
Contributor

One Date Range

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?

Labels (3)
1 Solution

Accepted Solutions

Re: Start Date and End Date from one Date Field

Try this


9 Replies
pradosh_thakur
Honored Contributor II

Re: Start Date and End Date from one Date Field

how does your data looks like ? provide some example.
Learning never stops.
qlikwiz123
Contributor

Re: Start Date and End Date from one Date Field

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
Contributor

Re: Start Date and End Date from one Date Field

@pradosh_thakur@sunny_talwar

Any thoughts on this one is really appreciated folks 🙂

Re: Start Date and End Date from one Date Field

Try this


qlikwiz123
Contributor

Re: Start Date and End Date from one Date Field

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

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

qlikwiz123
Contributor

Re: Start Date and End Date from one Date Field

PFA

Re: Start Date and End Date from one Date Field

May be try the attached

qlikwiz123
Contributor

Re: Start Date and End Date from one Date Field

Thank you so much.