Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
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 II
Specialist II

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

 

principal
Luminary Alumni
Luminary Alumni
Author

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