topic Re: Filtering expresions using $ in QlikView

Filtering expresions using $

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

If I have a sales expressions and I define:

sum( {$} sales)

then sales are filtered by current selection. My question is: Can I filter only by the selections done in one field??

That is, something like that:

sum( {$<city = city>} sales)

Ii doesn't work, because I want the expression filtered only by city, but If I make selecctions by other fileds , this selections affects the expression

Can anybody help me?

Thanks in advance

Re: Filtering expresions using $

Gysbert_Wassenaar — Wed, 18 May 2016 18:05:19 GMT

Yes, like this: sum( {1<city = P(city)>} sales)

Re: Filtering expresions using $

Colin-Albert — Wed, 18 May 2016 18:11:51 GMT

You can find more information on set analysis here.

Set Analysis: syntaxes, examples

Re: Filtering expresions using $

sunny_talwar — Wed, 18 May 2016 18:21:08 GMT

You can also try this:

Sum({1<city = $::city>} sales)

This is slightly different then the syntax provided by Gysbert.

Gysbert's solution will show all possible values of city. For instance if you make a selection in date field and for that particular date there are only 2 cities available, you will see the Sum(Sales) for all dates, but only those two cities. Where as the one provided above will only filter based on direct selection in city field.