Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Thank you!
Did you try using expression Avg(Score) ?