Variables in Set Analysis

[Ian1]

Hi All,

I'm fairly new to Qlik and looking for some help.

I've been looking to use the variable input tool to alter what is being displayed on my sheet similar to a filter.

The set analysis below displays tickets raised:

Count({$<Open_Date={">=$(=yearstart(today()))"}, Status-={'Cancelled'}, System-={'Q-Pulse'}, [Assignment Group]={'$(vVar)'}>} Open_Date )

Is it possible to use the variable input visual as a button which will set the assignment group to either all or a specific team?

I have tried using '*' for the input but that does not work. I have managed to get it working for the specific team just need guidance on how to display all.

Thanks

[andoryuu]

What happens if you flip your action between [Assignment Group]={'$(vVar)'} and [Assignment Group]= 

The empty equals sign (and technically you don't even need the equals sign) expands to an entire set.

[dplr-rn]

you can put the full set analysis part in the variable.

e.g.

Sum( {<$(vSetVariable)>} Open_Date )

customize the variable to include [Assignment Group]={'DepartmentName'} only if needed

[Ian1]

Thanks for your fast reply!

I've tried that just now using this:

Count({$<Open_Date={">=$(=yearstart(today()))"}, Status-={'Cancelled'}, $(vSetVariable)>} Open_Date )

It works when the variable is just set as [Assignment Group]

but it gives an error when it set it as [Assignment Group]={'The Team'} and gives nothing and no error when set as =[Assignment Group]='The Team'

[Ian1 · Accepted solution]

Managed to get it working.

Count({$<Open_Date={">=$(=yearstart(today()))"}, Status-={'Cancelled'}, [Assignment Group]={'$(vVar)'}>} Open_Date )

I  used '(*)' and that worked