topic Re: Set Analysis in QlikView https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/1426422#M459307 <HTML><HEAD></HEAD><BODY><P>Hi </P><P></P><P>I think you have to be more specific</P><P></P><P>regards</P><P>Pradosh</P></BODY></HTML> Tue, 10 Oct 2017 13:48:59 GMT pradosh_thakur 2017-10-10T13:48:59Z Set Analysis https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/1426421#M459306 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>How do i write the below if statement in Set analysis? Do we have to use any variable?</P><P></P><P>Any help is highly appreciated.</P><P></P><P>If( Avg(AtoB) &lt;= 0.083, Sum(Units)&nbsp; )</P></BODY></HTML> Tue, 10 Oct 2017 13:41:43 GMT https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/1426421#M459306 markgraham123 2017-10-10T13:41:43Z Re: Set Analysis https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/1426422#M459307 <HTML><HEAD></HEAD><BODY><P>Hi </P><P></P><P>I think you have to be more specific</P><P></P><P>regards</P><P>Pradosh</P></BODY></HTML> Tue, 10 Oct 2017 13:48:59 GMT https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/1426422#M459307 pradosh_thakur 2017-10-10T13:48:59Z Re: Set Analysis https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/1426423#M459308 <HTML><HEAD></HEAD><BODY><P>sum({&lt;column={"=Avg(AtoB) &lt;=0.083"}&gt;} Units)</P><P>but please elaborate more</P></BODY></HTML> Tue, 10 Oct 2017 13:50:50 GMT https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/1426423#M459308 ali_hijazi 2017-10-10T13:50:50Z Re: Set Analysis https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/1426424#M459309 <HTML><HEAD></HEAD><BODY><P>What is your dimension/s where you are carrying out this calculation?</P></BODY></HTML> Tue, 10 Oct 2017 14:12:29 GMT https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/1426424#M459309 sunny_talwar 2017-10-10T14:12:29Z