topic Re: set analysis in QlikView

set analysis

mario-sarkis — Wed, 17 Jun 2015 06:12:32 GMT

hey all ,

i have a field for example

001

002

003

004

005

006

how chan i write in the set analysis sum(ID<> 001 and ID <>002,amount)

Thank you,

PrashantSangle — Wed, 17 Jun 2015 06:18:32 GMT

Hi,

Sum({<ID-={'001','002'}>}Amount)

Sum(if( not wildmatch(ID,001,002),Amount))

Regards

MK_QSL — Wed, 17 Jun 2015 06:22:32 GMT

SUM({<ID = {'*'}-{'001','002'}>}amount)

Wed, 17 Jun 2015 06:23:29 GMT

Hi,

Try:

1--->Sum({<ID-={'001','002'}>}Amount)

2--->Sum({<ID={'<>001'},ID={'<>002'}>}Amount)

Regards,

Jemimah

Anonymous — Wed, 17 Jun 2015 06:28:47 GMT

sum({$<ID =E({<ID ={001,002}>})>}Amount)

Wed, 17 Jun 2015 06:33:21 GMT

Hi Mario,

Try like this:

Sum({<ID = {''001','002'} > } Amount )

It's simple :

Sum ---------------------------------------------> Expression

{< Dim = { unique record} >} - ----> Set

your req: Amount

Ramya.