Restricting rows based on a chart expression

[#1]

Hi

I'm trying to build a measurement model. In the attached example the TOP CITY chart is the final chart where the %Profit measurement is sitting.

However not all cities are eligible to compete in the TOP CITY. Those with less than 5 sales (see #Sales column) should be excluded. In this case Nice has only 1 sale and needs to be excluded.

How can this be done. See attached qvw.

[whiteline]

Hi.

You can use set analysis and calculated dimention instead of City:

=aggr(Only({<City={'=count(Gross)>=5'}>} City), City)

(toggle the checkbox 'supress when value is null')

This approcah allows dynamic exclusion depending on user selections.

And with calculated dimention you don't have to modify all your expressions with set analysis.

Anyway, consider creating a static falg field in script 'exclude' if it's possible accorfing to your requrements.

It's faster and allows the user to select that cities explicitly.

[lironbaram · Accepted solution]

hi

actually it quite simple

you can use dimension limits

have a look at the attach file

i created a dimension limit for the city dimension

you should note that dimension limits always uses the first expression in the table

[#4]

Please see attached.