Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
COUNT( { < [Department] = {$(=$(Department01)),$(=$(Department02))} > } StudentId)
COUNT( { < [Department] = {$(=$(Department01)),$(=$(Department02))} > } StudentId)