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

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
Valued Contributor III

Re: exclusion expresion

HI Try some thing like this,

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

9 Replies

Re: exclusion expresion

Hi try below for opposite

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


Regards

ASHFAQ

anbu1984
Honored Contributor III

Re: exclusion expresion

Try this

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


ravic906
Contributor III

Re: exclusion expresion

Hi,

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

HTH

Ravi N.

pradeepreddy
Valued Contributor II

Re: exclusion expresion


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

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

Not applicable

Re: exclusion expresion

It doesn't work:

Neither <> and nor -=

Re: exclusion expresion

Hi

Can you post your sample app.

Regards

ASHFAQ

pradeepreddy
Valued Contributor II

Re: exclusion expresion


try this..

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

sasikanth
Valued Contributor III

Re: exclusion expresion

HI Try some thing like this,

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

Not applicable

Re: exclusion expresion

Thnaks to all!

Community Browser