Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
kev6brown
Partner
Partner

Make a selection without selecting

Hi

As an example I have the following table - 

FruitShopPrice
Applea1
Bananab2
Strawberryc3
Lemona4
Melonb

5

 

What i would like to be able to do is have 2 expressions, one for the price of a fruit depending on the selection made (that's fine, i've got that expression), but the second expression I would like an average of the Shops where the selection comes from, so, I select apple and I get 

Expression 1 - Sum Apple

Expression 2 - Average Shop a (Apple & Lemon)

Shop a hasn't been selected so how can I get that expression to work?

Thanks

Kev

1 Solution

Accepted Solutions
stevejoyce
Creator III
Creator III

This will avg all Prices, ignore Fruit selection, for Shops that are resulted in your selection.

Avg({<Fruit=, Shop=P(Shop) >} Price)

View solution in original post

1 Reply
stevejoyce
Creator III
Creator III

This will avg all Prices, ignore Fruit selection, for Shops that are resulted in your selection.

Avg({<Fruit=, Shop=P(Shop) >} Price)

View solution in original post