Discussion Board for collaboration on QlikView Layout & Visualizations.
I am trying to apply a Date Range Filter, which spans a month ,on two date fields simultaneously.
This Filtering is applied using Button Click Event.
The Filter is not applied since both the fields are not satisfying the date range filters simultaneously.
In such situation the expected behavior is that the Associative model of Qlikview should return Zero Rows since date range filter ideally yields zero data.
We tried to apply filter on both the fields and the default Qilkview behaviour is that Filter is applied on only one field and the Second Field's filter is Ignored by Qlikview.
Below example best explains the issue that we were facing.
For the Data Sample in Below Table:
If the Date Filters to be applied on both From Date and To Date are:
For the above two conditions as filters ,the expected Result is the row with Row_Identity column having value A1 alone displayed.
This simultaneous Filtering of two Columns with the given Date Range(1-Jan-2018 to 31-Jan-2018) has to be achieved in a single Qlikview button click.