topic Re: Set analysis statement for If statement in QlikView https://community.qlik.com/t5/QlikView/Set-analysis-statement-for-If-statement/m-p/910250#M468958 <HTML><HEAD></HEAD><BODY><P>Thanq Marcus <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Tue, 04 Aug 2015 15:12:14 GMT markgraham123 2015-08-04T15:12:14Z Set analysis statement for If statement https://community.qlik.com/t5/QlikView/Set-analysis-statement-for-If-statement/m-p/910248#M468956 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>Regarding performance, Set analysis or If statement???</P><P>Which would work quicker.</P><P></P><P>Could someone help me in scripting the below statement using Set analysis</P><P></P><P>=count(DISTINCT(If(Name='John',Awards)))</P></BODY></HTML> Tue, 04 Aug 2015 15:02:09 GMT https://community.qlik.com/t5/QlikView/Set-analysis-statement-for-If-statement/m-p/910248#M468956 markgraham123 2015-08-04T15:02:09Z Re: Set analysis statement for If statement https://community.qlik.com/t5/QlikView/Set-analysis-statement-for-If-statement/m-p/910249#M468957 <HTML><HEAD></HEAD><BODY><P>Set analysis is definitely quicker!</P><P></P><P>count({$&lt;Name={'John'}&gt;} DISTINCT Awards)</P></BODY></HTML> Tue, 04 Aug 2015 15:05:46 GMT https://community.qlik.com/t5/QlikView/Set-analysis-statement-for-If-statement/m-p/910249#M468957 marcus_malinow 2015-08-04T15:05:46Z Re: Set analysis statement for If statement https://community.qlik.com/t5/QlikView/Set-analysis-statement-for-If-statement/m-p/910250#M468958 <HTML><HEAD></HEAD><BODY><P>Thanq Marcus <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Tue, 04 Aug 2015 15:12:14 GMT https://community.qlik.com/t5/QlikView/Set-analysis-statement-for-If-statement/m-p/910250#M468958 markgraham123 2015-08-04T15:12:14Z