1 Reply Latest reply: Dec 5, 2016 2:27 PM by Rupam Das RSS

    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?