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.

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

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)

 

Recconing_2-1655920158075.png

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

Recconing_1-1655919863755.png

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