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: 
Not applicable

Set analysis - multiple variables in comparisson

Dear members,

I am using set analysis to count students in their departments.

COUNT( { < [Department]  = {'Math', 'Biology'}  > } StudentId)

Now I need to use parameters Department01, Department02 instead of hardcoded strings.

In Qlik Sence it works only for one parameter:

COUNT( { < [Department]  = $(Department01)  > } StudentId)

I am not able to use two or three parameters. The code below does not work in QS:

COUNT( { < [Department]  = {$(Department01),$(Department02)}  > } StudentId)

I just know it is possible in Qlik View.

Any idea please how to write a code with two or more parameters?

Thanks.

1 Solution

Accepted Solutions
rupamjyotidas
Specialist
Specialist

COUNT( { < [Department]  = {$(=$(Department01)),$(=$(Department02))}  > } StudentId)

View solution in original post

1 Reply
rupamjyotidas
Specialist
Specialist

COUNT( { < [Department]  = {$(=$(Department01)),$(=$(Department02))}  > } StudentId)