topic How to write in Set Analysis in QlikView https://community.qlik.com/t5/QlikView/How-to-write-in-Set-Analysis/m-p/298908#M1194339 <HTML><HEAD></HEAD><BODY><P>can y try this one</P><P></P><P>sum({&lt;FACT_TYPE={'Current'},FLAG_HEALTH_REPORT={1} ,STAGE-= {'Lost','-','Expired','Design Win','Project Cancelled'} &gt;}TOTAL_VALUE))</P></BODY></HTML> Fri, 17 Jun 2011 16:48:55 GMT 2011-06-17T16:48:55Z How to write in Set Analysis https://community.qlik.com/t5/QlikView/How-to-write-in-Set-Analysis/m-p/298907#M1194338 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>Though its Friday, but still I am here to bug and buzz.</P><P>How do i write this following statement in set analysis,</P><P></P><P>sum(total if(FACT_TYPE='Current' AND FLAG_HEALTH_REPORT='1' AND STAGE&lt;&gt; 'Lost' AND STAGE &lt;&gt; '-' AND STAGE &lt;&gt; 'Expired' AND STAGE &lt;&gt;'Design Win' AND STAGE &lt;&gt; 'Project Cancelled',TOTAL_VALUE))</P><P></P><P></P><P>Thanks,</P><P>Bikash</P></BODY></HTML> Fri, 17 Jun 2011 16:45:44 GMT https://community.qlik.com/t5/QlikView/How-to-write-in-Set-Analysis/m-p/298907#M1194338 2011-06-17T16:45:44Z How to write in Set Analysis https://community.qlik.com/t5/QlikView/How-to-write-in-Set-Analysis/m-p/298908#M1194339 <HTML><HEAD></HEAD><BODY><P>can y try this one</P><P></P><P>sum({&lt;FACT_TYPE={'Current'},FLAG_HEALTH_REPORT={1} ,STAGE-= {'Lost','-','Expired','Design Win','Project Cancelled'} &gt;}TOTAL_VALUE))</P></BODY></HTML> Fri, 17 Jun 2011 16:48:55 GMT https://community.qlik.com/t5/QlikView/How-to-write-in-Set-Analysis/m-p/298908#M1194339 2011-06-17T16:48:55Z