Skip to main content

New to Qlik Sense

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

QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
Showing results for 
Search instead for 
Did you mean: 

Find a dimension value based on the average of measure

Hello everyone,

So, I have this example table with the 3 measurements determined by the formula:

Avg({$<Brand={'x'}>} Price/Grammage*500)



And I would like to turn it into something close to this table


So, I need to find which brand has the lowest average price, and the same for the highest average price.
And check if my brand is below the average of the lowest priced brand or above the average of the highest priced brand.

But I have some limitations, they are:
The brands will vary according to another dimension (for example: seller) and I should ignore null values

I've tried several ways but all were extremely large (taking up 30 lines of code for 1 seller)

Labels (6)
0 Replies