Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $400 before Dec 31st: 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)