topic Re: exclude the selection in a expresion in QlikView

exclude the selection in a expresion

Wed, 08 Jul 2015 10:03:28 GMT

Hello,

I need to do a table as follow:

If i select one country ( Country1), a table that contains the cummulate of all markets but the one selected. If i select other country the same excluding this selection.. Always excluding in the expresion the country selested. is this posible?

MARKET (w/o selection)	5
COUNTRY 1	3
TOT	8

MARKET (w/o selection)	6
COUNTRY 2	2
TOT	8

Thanks

Re: exclude the selection in a expresion

sunny_talwar — Wed, 08 Jul 2015 10:06:13 GMT

May be something like this in your set analysis expression:

{<Country = e(Country)>} or

{<Country -= p(Country)>}

Re: exclude the selection in a expresion

Anonymous — Wed, 08 Jul 2015 10:07:25 GMT

Belen,

If your expression is

=Sum(Sales)

to calculate this with the excluded values of markets:

=Sum({<Market=e(Market)>} Sales)

Marc.

Re: exclude the selection in a expresion

avinashelite — Wed, 08 Jul 2015 10:12:15 GMT

try like :

=sum({<Agent=e(Agent)>}cost)

Re: exclude the selection in a expresion

Wed, 08 Jul 2015 10:16:34 GMT

It Works, but it is posible to do do the filter in the dimensión? So in this case i can have the Market without the selection and the selection?

Re: exclude the selection in a expresion

Wed, 08 Jul 2015 10:32:05 GMT

Ok! Thanks Sunindia