topic Re: IF Statement to Set Analysis in Concat() function in QlikView https://community.qlik.com/t5/QlikView/IF-Statement-to-Set-Analysis-in-Concat-function/m-p/674184#M244799 <HTML><HEAD></HEAD><BODY><P>Try:</P><P></P><P><STRONG>=Concat({&lt;Product = {'=sum(Revenue)&gt;300'}&gt;}Product, ',')</STRONG></P><P></P><P>Hope this helps!</P></BODY></HTML> Tue, 23 Sep 2014 14:48:11 GMT jerem1234 2014-09-23T14:48:11Z IF Statement to Set Analysis in Concat() function https://community.qlik.com/t5/QlikView/IF-Statement-to-Set-Analysis-in-Concat-function/m-p/674183#M244798 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">Dear Community,</SPAN></P><P></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">Please write the below expression in set analysis without using IF Statement.</SPAN></P><P></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;"><SPAN style="font-size: 12pt;">=</SPAN><STRONG style="font-size: 12pt;">Concat(IF(aggr(Sum(Revenue),Product)&gt;300,Product),',')</STRONG></SPAN></P><P></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">Thanks in advance.</SPAN></P><P></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">Regards,</SPAN></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">Manideep</SPAN></P></BODY></HTML> Tue, 23 Sep 2014 14:42:03 GMT https://community.qlik.com/t5/QlikView/IF-Statement-to-Set-Analysis-in-Concat-function/m-p/674183#M244798 manideep78 2014-09-23T14:42:03Z Re: IF Statement to Set Analysis in Concat() function https://community.qlik.com/t5/QlikView/IF-Statement-to-Set-Analysis-in-Concat-function/m-p/674184#M244799 <HTML><HEAD></HEAD><BODY><P>Try:</P><P></P><P><STRONG>=Concat({&lt;Product = {'=sum(Revenue)&gt;300'}&gt;}Product, ',')</STRONG></P><P></P><P>Hope this helps!</P></BODY></HTML> Tue, 23 Sep 2014 14:48:11 GMT https://community.qlik.com/t5/QlikView/IF-Statement-to-Set-Analysis-in-Concat-function/m-p/674184#M244799 jerem1234 2014-09-23T14:48:11Z Re: IF Statement to Set Analysis in Concat() function https://community.qlik.com/t5/QlikView/IF-Statement-to-Set-Analysis-in-Concat-function/m-p/674185#M244800 <HTML><HEAD></HEAD><BODY><P>Perfect! Thank you <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Tue, 23 Sep 2014 14:53:03 GMT https://community.qlik.com/t5/QlikView/IF-Statement-to-Set-Analysis-in-Concat-function/m-p/674185#M244800 manideep78 2014-09-23T14:53:03Z