Expression not getting filtered correctly

Wed, 25 Nov 2020 16:16:04 GMT

My requirement is to identify the cases of ECI that have repeated when compared with the previous month.

I have been able to use the following expression

=count( DISTINCT {
<ECI=p({<Created_Month={'$(=MonthName(Max(CREATED_DATE)))'}>}ECI)>
*
<ECI=p({<Created_Month={'$(=MonthName(Max(CREATED_DATE),-1))'}>}ECI)>
} ECI)

and it works fine. The issue is I am unable to filter it correctly.

For example:

I have another field in the same table but it is unable to filter the data according to the field.

I have attached the sample

I understand from the data that the ECI - 2964 and 4499 are present in all the Customer Data Quality dimension.

But only in CIP City is it occurring every month

topic Expression not getting filtered correctly in QlikView

Expression not getting filtered correctly