Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to Find a person that has one specific and other categories

Supposedly I have a table like this:

Client ID     Category

      1          No SPMF

      1          Hope Fund

      2          No SPMF

      3          Sinda Bursary

      4          No SPMF

      4          Sinda Bursary

      4          Hope Fund

How do I get an active selection for the clients that not only have 'No SPMF' Category but also other Category(es)? In this case, I should have ClientID 1 and 4 active.

    

Thank you.

1 Reply
maxgro
MVP
MVP

dimension         

Client ID

expression         

count({$<Category={'No SPMF'}>} Category)=1 and count({$<Category-={'No SPMF'}>} Category)>0