Unable to apply Date Range Filter on more than one date fields in a single button click

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

Hi Friends,

I am trying to apply a Date Range Filter which spans a month apart 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 yields zero data.

We tried and the default qilkview behaviour is that Filter is applied on only one field and the Second Field's filter is Ignored.

Below example best explains the issue that we were facing.

For the Data Sample in Below Table:

Row_Identity	FromDate	ToDate
A1	1-Jan-2018	31-Jan-2018
A2	1-Jan-2018	28-Feb-2018
A3	1-Jan-2018	31-Mar-2018
A4	1-Jan-2018	30-Apr-2018
A5	1-Jan-2018	31-May-2018
A6	1-Jan-2018	30-Jun-2018

If the Date Filters to be applied on both From Date and To Date are:

From Date Should be between 1-Jan-2018 and 31-Jan-2018 and
To Date Should be between 1-Jan-2018 and 31-Jan-2018

For the above two conditions as filters ,the expected Result is the row with Row_Identity column having value A1 alone displayed.

i.e,

Row_Identity	FromDate	ToDate
A1	1-Jan-2018	31-Jan-2018

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.

Message was edited by: prathapreddy ambati included exapmle to explain the issue.

topic Unable to apply Date Range Filter on more than one date fields in a single button click in QlikView

Unable to apply Date Range Filter on more than one date fields in a single button click