Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

exclude the selection in a expresion


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 13
TOT8

 

MARKET
  (w/o selection)
6
COUNTRY 22
TOT

8

Thanks

5 Replies

Re: exclude the selection in a expresion

May be something like this in your set analysis expression:

{<Country = e(Country)>} or

{<Country -= p(Country)>}

marcarreras
Valued Contributor

Re: exclude the selection in a expresion

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

try like :

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

Not applicable

Re: exclude the selection in a expresion

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?

Not applicable

Re: exclude the selection in a expresion

Ok! Thanks Sunindia

Community Browser