Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
principal
Luminary Alumni
Luminary Alumni

Qlikview Expression

Hi,

I have a number of Customers where the orders are at a specific phase, see below example, I only want to count those customer where all orders are at phase 11, Customer A has some but not all, Customer C is the only Customer where all orders are at phase 11.

I want to display the result in a Text Object

CustomerOrder IDPhase
A110
A211
A311
A412
B52
B61
B71
B81
C911
C1011
C1111
C1211
2 Replies
jwjackso
Specialist III
Specialist III

=Count({<Customer=E({<Phase-={'11'}>}Customer)>}Distinct Customer)

 

principal
Luminary Alumni
Luminary Alumni
Author

That did return the correct result, can anyone else help?