topic Re: From IF Statement to Set Analysis in QlikView https://community.qlik.com/t5/QlikView/From-IF-Statement-to-Set-Analysis/m-p/429506#M160105 <HTML><HEAD></HEAD><BODY><P>That can't be rewritten to a set analysis expression. If you rewrite it to <SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">IF(month(DATE) &lt; 3 OR month(DATE) = 12, sum(IM*GBP)</SPAN>) and check the option Suppress Zero-Values and Suppress Missing on the Presentation tab of the properties window then the row won't be displayed (unless another expression on that row does have a value).</P></BODY></HTML> Mon, 11 Mar 2013 15:47:22 GMT Gysbert_Wassenaar 2013-03-11T15:47:22Z From IF Statement to Set Analysis https://community.qlik.com/t5/QlikView/From-IF-Statement-to-Set-Analysis/m-p/429505#M160104 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I have this IF statement which works:</P><P></P><P>IF(month(DATE) &lt; 3 OR month(DATE) = 12, sum(IM*GBP),'no data')</P><P></P><P>How would I transform it into set analysis? Is it possible?</P><P></P><P>Also, instead of having 'no data', is it possible to just not display the row at all?</P><P></P><P>Thanks</P></BODY></HTML> Mon, 11 Mar 2013 15:41:00 GMT https://community.qlik.com/t5/QlikView/From-IF-Statement-to-Set-Analysis/m-p/429505#M160104 2013-03-11T15:41:00Z Re: From IF Statement to Set Analysis https://community.qlik.com/t5/QlikView/From-IF-Statement-to-Set-Analysis/m-p/429506#M160105 <HTML><HEAD></HEAD><BODY><P>That can't be rewritten to a set analysis expression. If you rewrite it to <SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">IF(month(DATE) &lt; 3 OR month(DATE) = 12, sum(IM*GBP)</SPAN>) and check the option Suppress Zero-Values and Suppress Missing on the Presentation tab of the properties window then the row won't be displayed (unless another expression on that row does have a value).</P></BODY></HTML> Mon, 11 Mar 2013 15:47:22 GMT https://community.qlik.com/t5/QlikView/From-IF-Statement-to-Set-Analysis/m-p/429506#M160105 Gysbert_Wassenaar 2013-03-11T15:47:22Z Re: From IF Statement to Set Analysis https://community.qlik.com/t5/QlikView/From-IF-Statement-to-Set-Analysis/m-p/429507#M160106 <HTML><HEAD></HEAD><BODY><P>Thanks for help. That's the problem, other expressions have values so the whole row is displayed and checking Suppress boxes doesn't work.</P></BODY></HTML> Mon, 11 Mar 2013 15:50:02 GMT https://community.qlik.com/t5/QlikView/From-IF-Statement-to-Set-Analysis/m-p/429507#M160106 2013-03-11T15:50:02Z