Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
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
MVP
MVP

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

dimension         

Client ID

expression         

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