Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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