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

exclusion expresion

If i want to include in my chart, this expresión:

sum {$<[Consortium]={'xxxx'},[Agency]={'55302472','55868995'>}NUM_PAX_BKD_LB )

And also the opposite: I mean, all the ones that belongs to Consortium 'xxx' but Agency='55302472','55868995'.

If i try this:   ({$<Weeks=,[Consortium]={'xxxx'},[Agency]<>{'55302472','55868995'>}NUM_PAX_BKD_LB )

Doesnt work.

Could someone help me?

Thanks!

1 Solution

Accepted Solutions
sasikanth
Master
Master

HI Try some thing like this,

sum {$<[Consortium]={'xxxx'},[Agency]={*}- {'55302472','55868995'>}NUM_PAX_BKD_LB )

View solution in original post

9 Replies
ashfaq_haseeb
Champion III
Champion III

Hi try below for opposite

If i try this:   sum({$<Weeks=,[Consortium]={'xxxx'},[Agency]-={'55302472','55868995'>}NUM_PAX_BKD_LB )


Regards

ASHFAQ

anbu1984
Master III
Master III

Try this

sum {$<[Consortium]={'xxxx'},[Agency]-={'55302472','55868995'>}NUM_PAX_BKD_LB )


Anonymous
Not applicable
Author

Hi,

In set analysis, not equal is not <> but -=

HTH

Ravi N.

PradeepReddy
Specialist II
Specialist II


might be the syntax issue.. try this...

sum({$<Weeks=,[Consortium]={'xxxx'},[Agency]<>{'55302472','55868995'}>}NUM_PAX_BKD_LB )

Not applicable
Author

It doesn't work:

Neither <> and nor -=

ashfaq_haseeb
Champion III
Champion III

Hi

Can you post your sample app.

Regards

ASHFAQ

PradeepReddy
Specialist II
Specialist II


try this..

sum({$<Weeks=,[Consortium]={'xxxx'},[Agency]={'*'}-{'55302472','55868995'}>}NUM_PAX_BKD_LB )

sasikanth
Master
Master

HI Try some thing like this,

sum {$<[Consortium]={'xxxx'},[Agency]={*}- {'55302472','55868995'>}NUM_PAX_BKD_LB )

Not applicable
Author

Thnaks to all!