topic Re: How to create a view between two date feilds from different colums in QlikView

How to create a view between two date feilds from different colums

Wed, 25 Nov 2020 16:16:04 GMT

Hi, I have a table which is based on projects which are being undertaken, I have a whole range of data, the projects have a start date in one column and an end date in another column.

Is there an easy way to select to show data based on an input to show what projects where current at the input date selected or between a period of time with a start and end date.

E.g.. I want to see all projects that were being worked on from Dec 2015 to Feb 2016. So the Start date must be up to and including the 28/2/2016 from the Start Date field and The End Date must be after and including the 1/12/2015 from the end date field.

Re: How to create a view between two date feilds from different colums

adamdavi3s — Wed, 01 Feb 2017 08:23:12 GMT

Something like:

=only({<EndDate={">='01/12/2015'"},StartDate={"<='28/02/2016'"}>}ProjectCode)

Re: How to create a view between two date feilds from different colums

omkarvamsi — Wed, 01 Feb 2017 08:44:37 GMT

Hi Adam,

can you give sample data so that i could help

we can solve this by interval match concept.

Regards

Omkar