Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
sunny_talwar

May be something like this in your set analysis expression:

{<Country = e(Country)>} or

{<Country -= p(Country)>}

Anonymous
Not applicable
Author

Belen,

If your expression is

=Sum(Sales)

to calculate this with the excluded values of markets:

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

Marc.

avinashelite

try like :

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

Not applicable
Author

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
Author

Ok! Thanks Sunindia