How to test for the associated value of a listbox in an expression?
Hello QlikCommunity,
Is there a way test for the associated value of a listbox in an expression? I have 2 listboxes as follows.
Client
PG&E
AT&T
Tier
1
2
"PG&E" is currently selected, and tier 1 is the associated value. I can use an expression to display the associated value in a straight table or a simple text box like this:
=Tier
However, I can't test for that value in an expression with set analysis. Basically I want to average the score where the Tier's value equals the associated value of the currently selected value in the Client listbox. I can't seem to make the following expression work.
=Avg( {$ <Tier = {$Tier} > } , score )
I know there's something wrong with the expression, but I can't figure out what. I would appreciate any help you could provide.