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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
principal
Partner - Contributor III
Partner - Contributor III

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
Labels (1)
2 Replies
jwjackso
Specialist III
Specialist III

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

 

principal
Partner - Contributor III
Partner - Contributor III
Author

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