topic Set analysis (if + or) in QlikView

Set analysis (if + or)

Thu, 13 Feb 2014 19:06:44 GMT

how can I transform this expression to set analysis :

sum (if(Field1='A' or Field2='1',amount))

Regards,

Yacine

maxgro — Thu, 13 Feb 2014 19:09:09 GMT

try with

sum({$ <Field1={A}> + <Field2={1}> } amount)

Nicole-Smith — Thu, 13 Feb 2014 19:09:16 GMT

sum({<Field1={'A'}>+<Field2={'1'}>} amount)

Thu, 13 Feb 2014 19:09:59 GMT

sum({<Field1={'A'}>+<Field2={1}>} amount)

Thanks

maxgro — Thu, 13 Feb 2014 19:14:19 GMT

you find all the 3 previous expressions and many others interesting things here