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

    Set analysis - multiple variables in comparisson

    Lukas Orsin

      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.