Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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)

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
yanivvl0
Creator III
Creator III
Author

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