Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

dynamic_girl
Contributor

requirement

field1='value' and (field2='NA' or isnull(field3)) and field4<>'NA' and (field5<>'null' or field6<>'null')

how to cnvert this to set analysis expression

2 Replies
zhadrakas
Valued Contributor II

Re: requirement

dont know how to write or Operator in set Analysis. But you mix if and set analysis

=sum({<field1={'value'}, field4<>{'NA'}>}if((field5<>'null' or field6<>'null') AND (field2='NA' or isnull(field3)), YOUR_FIELD))

dynamic_girl
Contributor

Re: requirement

this is not working,is there any other syntax for set analysis for above expression?