How to filter for values between dates?

mparker123 — Wed, 25 Nov 2020 16:16:04 GMT

Hello All,

I am trying to filter a straight table by inputting date ranges into either an "Input Box", "Text Object" or something else? The key is I want both fields to reference the same data. For instance, I have a field called Start Date and Due Date. I DO NOT want to filter on the start date. I want to be able to enter Two dates into either the "Input Box" ,"Text Object", or something else and have it filter BY Due Date only.

Example of Straight Table:

Project Name	Summary	Issue Type	Start Date	Due Date
PMO Jelly Bean	Jelly Bean	New Client	5/1/2017	6/30/2017
PMO Kit-Kat	Kit-Kat	New Client	2/14/2017	10/1/2017

I want to be able to enter any dates and have it filter accordingly. So if i enter in 6/1/2017 in one box and 6/30/2017 in other box I should only get PMO Jelly Bean. Again, If I enter in 6/31/2017 to 10/5/2017 I should only be seeing PMO Kit-Kat.

I am relatively new to qlikview and have look at other discussions on date ranges and can't seem to find one that will filter the data correctly. Thank You.

Re: How to filter for values between dates?

Anil_Babu_Samineni — Mon, 19 Jun 2017 13:07:42 GMT

Create 2 variables and then use those variables either Slider / Calendar / Variable objects.

Only({<Date = {">=$(vFirstSortDate) <=$(vLastSortDate)"}>}Summary)

Re: How to filter for values between dates?

mparker123 — Mon, 19 Jun 2017 13:49:03 GMT

I created both variables by going to the setting variable overview and creating 2 new ones with the formula you have provide. When I type in the dates nothing happens to the straight table.

topic Re: How to filter for values between dates? in QlikView

How to filter for values between dates?

Re: How to filter for values between dates?

Re: How to filter for values between dates?