Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
If you don't want to use Input box, but want to use input from Filter Panel you can use GetFieldSelections:
Let vProgram = GetFieldSelections([Program],'","')
And use it like this in formula. However, you might want to consider limiting the formula to use only 1 value of the selected, as more selected values may cause troubles with your formulas. Check Qlik help
Hi,
can create the variable and link it to an input box
as well as using this variable in all measures
regards
If you don't want to use Input box, but want to use input from Filter Panel you can use GetFieldSelections:
Let vProgram = GetFieldSelections([Program],'","')
And use it like this in formula. However, you might want to consider limiting the formula to use only 1 value of the selected, as more selected values may cause troubles with your formulas. Check Qlik help