Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set analysis (if + or)

Hi

how can I transform this expression to set analysis :

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

Regards,

Yacine

1 Solution

Accepted Solutions
maxgro
MVP
MVP

try with

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

View solution in original post

4 Replies
maxgro
MVP
MVP

try with

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

Nicole-Smith

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

Not applicable
Author

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

Thanks

AJ

maxgro
MVP
MVP

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

Set Analysis: syntaxes, examples