Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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.

Thank you!

1 Reply
nagaiank
Specialist III
Specialist III

Did you try using expression  Avg(Score) ?