topic Re: Restricting rows based on a chart expression in QlikView

Restricting rows based on a chart expression

Mon, 09 Jun 2014 07:18:50 GMT

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.

Re: Restricting rows based on a chart expression

whiteline — Mon, 09 Jun 2014 07:34:13 GMT

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.

Re: Restricting rows based on a chart expression

lironbaram — Mon, 09 Jun 2014 08:04:52 GMT

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

Re: Re: Restricting rows based on a chart expression

Mon, 09 Jun 2014 08:12:29 GMT

Please see attached.