This content has been marked as final. Show 2 replies
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.