topic Re: sum with exclusion in QlikView

sum with exclusion

Thu, 17 Apr 2014 13:12:07 GMT

Hi all,

how can I exclude some from a calculation?

for example

Salesman Sales

A 20

B 35

C 20

D 21

A 32

B 2

and I want to make a sum of sales without B & C; and when I filter Salesman A, the sum must be just for Salesman A

Thanks,

Cosmin

its_anandrjs — Thu, 17 Apr 2014 13:23:00 GMT

Oh Sorry i forget now check and yes as always Gysbert is correct

You can try like

Dimension:- Salesman

Expression:- sum({$<Salesman-={'B','C'}>}Sales)

Gysbert_Wassenaar — Thu, 17 Apr 2014 13:30:01 GMT

sum({$*<Salesman-={'B','C'}>}Sales)

Thu, 17 Apr 2014 13:33:23 GMT

Hi,

the sum for B+C is ok

but if I filter salesman B the sum is also B+C

thanks

Thu, 17 Apr 2014 13:40:44 GMT

Thanks Gysbert,

as always, it worked

best regards,

Cosmin

fkeuroglian — Thu, 17 Apr 2014 13:44:57 GMT

Hi, try this in the expression

SUM({<Salesman-={'B','C'}>} SALES)

see this link and this manual , will be useful to the set analisys

Fernando

Fri, 25 Apr 2014 14:51:36 GMT

very useful

thanks