Filtering data issues

[mingyu]

Qlik Sense uses TrialPhase, GroupDose, Type, and AEGrade as filtering dimensions. I need to create an expression where the result changes only with the filtering of TrialPhase and GroupDose. When filtering Type or AEGrade, the expression's result should remain unaffected. The objective is to achieve count(distinct SUBJECT).

I've written an expression, but the results are the opposite of what I intended.

count({<TrialPhase=,GroupDose=>} DISTINCT SUBJECT)

[Parthiban]

Hi,

count({<Type=,  AEGrade=>} DISTINCT SUBJECT)

[mingyu]

If that's the case, would I have to write for each column if there are many, or is there another way?

[Parthiban]

Check with this below link,

Ignore all selections except some specific fields using Set Analysis

[Parthiban]

Try,

=Count({$<[$(=Concat({1<$Field-={'TrialPhase','GroupDose'}>}distinct $Field,']=,[')&']=')>} DISTINCT SUBJECT)

[mingyu]

Okay. thank you.