Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
mingyu
Contributor III
Contributor III

How to let the count change when two filters changes?

Hi,

I want to count the distinct subjects only when 'TrialPhase' and 'GroupDose' changes.  I tried the following, but it does not work

COUNT(DISTINCT TOTAL {<TrialPhase, GroupDose>} SUBJECT)

Please help

Thanks

Labels (4)
1 Reply
Ahidhar
Creator III
Creator III

try this 

if(getselectedcount(TrialPhase)>0 and getselectedcount(GroupDose)>0,null(),count(SUBJECT))