Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Expression not getting filtered correctly

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

q2.JPG

0 Replies