topic Re: requirement in QlikView https://community.qlik.com/t5/QlikView/requirement/m-p/14041#M2323 <HTML><HEAD></HEAD><BODY><P>dont know how to write or Operator in set Analysis. But you mix if and set analysis</P><P><SPAN style="font-size: 8pt;">=</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">sum</SPAN><SPAN style="font-size: 8pt;">({&lt;field1={'value'}, field4&lt;&gt;{'NA'}&gt;}if((field5&lt;&gt;'null' or field6&lt;&gt;'null') AND (field2='NA' or isnull(field3)), YOUR_FIELD)) </SPAN></P><P></P></BODY></HTML> Tue, 13 Feb 2018 08:09:32 GMT zhadrakas 2018-02-13T08:09:32Z requirement https://community.qlik.com/t5/QlikView/requirement/m-p/14040#M2322 <HTML><HEAD></HEAD><BODY><P>field1='value' and (field2='NA' or isnull(field3)) and field4&lt;&gt;'NA' and (field5&lt;&gt;'null' or field6&lt;&gt;'null')</P><P></P><P></P><P>how to cnvert this to set analysis expression</P></BODY></HTML> Tue, 13 Feb 2018 06:16:59 GMT https://community.qlik.com/t5/QlikView/requirement/m-p/14040#M2322 Anonymous 2018-02-13T06:16:59Z Re: requirement https://community.qlik.com/t5/QlikView/requirement/m-p/14041#M2323 <HTML><HEAD></HEAD><BODY><P>dont know how to write or Operator in set Analysis. But you mix if and set analysis</P><P><SPAN style="font-size: 8pt;">=</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">sum</SPAN><SPAN style="font-size: 8pt;">({&lt;field1={'value'}, field4&lt;&gt;{'NA'}&gt;}if((field5&lt;&gt;'null' or field6&lt;&gt;'null') AND (field2='NA' or isnull(field3)), YOUR_FIELD)) </SPAN></P><P></P></BODY></HTML> Tue, 13 Feb 2018 08:09:32 GMT https://community.qlik.com/t5/QlikView/requirement/m-p/14041#M2323 zhadrakas 2018-02-13T08:09:32Z Re: requirement https://community.qlik.com/t5/QlikView/requirement/m-p/14042#M2324 <HTML><HEAD></HEAD><BODY><P>this is not working,is there any other syntax for set analysis for above expression?</P></BODY></HTML> Tue, 20 Feb 2018 07:05:31 GMT https://community.qlik.com/t5/QlikView/requirement/m-p/14042#M2324 Anonymous 2018-02-20T07:05:31Z