Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
yanivvl0
Creator III
Creator III

How to count members from group except other group ?

hi to all ,

i need for each sys - to count (dynamicly) workers , for example from grp 1 that not exist in grp 2 ( or from grp 3 that not exist in grp 1 ....)  -  the count replies only to status 1 :

sys4grp.PNG

( class is no metter )

to chose those 2 groups from list-box - and see result in a text box ,

thanks..

more specific : if i chose  grp 1 VS grp 3 - the result must be 3 because wrk 1,wrk 3,wrk 4 in grp 1 BUT not in grp 3 ,

( and all of there rows status=1 ). !

2 Replies
Anil_Babu_Samineni

Do you mean this?

Count({<status = {1}>} Measure)

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
yanivvl0
Creator III
Creator III
Author

yea, please see "more specific" example , thanks Anil.