topic Re: exclusion expresion in QlikView

exclusion expresion

Tue, 27 May 2014 09:33:40 GMT

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!

Re: exclusion expresion

ashfaq_haseeb — Tue, 27 May 2014 09:38:59 GMT

Hi try below for opposite

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

Regards

ASHFAQ

Re: exclusion expresion

anbu1984 — Tue, 27 May 2014 09:39:11 GMT

Try this

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

Re: exclusion expresion

Anonymous — Tue, 27 May 2014 09:48:58 GMT

Hi,

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

HTH

Ravi N.

Re: exclusion expresion

PradeepReddy — Tue, 27 May 2014 09:57:32 GMT

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

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

Re: exclusion expresion

Tue, 27 May 2014 10:11:23 GMT

It doesn't work:

Neither <> and nor -=

Re: exclusion expresion

ashfaq_haseeb — Tue, 27 May 2014 10:12:50 GMT

Can you post your sample app.

Regards

ASHFAQ

Re: exclusion expresion

PradeepReddy — Tue, 27 May 2014 10:16:07 GMT

try this..

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

Re: exclusion expresion

sasikanth — Tue, 27 May 2014 10:17:30 GMT

HI Try some thing like this,

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

Re: exclusion expresion

Tue, 27 May 2014 10:27:55 GMT

Thnaks to all!