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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
youss123
Contributor III
Contributor III

Graph Expression : count

hello All,

I want to count the number of patients who responded to all the 3 questions : question 1 , 2 , 3.

But this expression is not working. 

It does not give the number of patients how reponded the 3 questions  , but rather the number of patients who answered one of the 3 questions.

=count({ <[question]={'question1'}, [question]={'question2'}, [question]={'question3}, [responded]= {'Yes'} >}distinct [KEY - Patient])

Many thanks in advance

11 Replies
youss123
Contributor III
Contributor III
Author

Thank you vm

youss123
Contributor III
Contributor III
Author

I have another question please, how can I set up this solution in the script part, to make a filter which where I can have all the possible combinations:

The respondents just to question 1 and 2 , or 2 and 3 , or 1 and 3 ....

 

Thank you in advence