topic Re: Set Analysis Expression in QlikView https://community.qlik.com/t5/QlikView/Set-Analysis-Expression/m-p/993931#M338382 <HTML><HEAD></HEAD><BODY><P>I think</P><P>sum of sales vol for year 2015, excluding c1 blocked, excluding d1 blocked, adding cust id 43524</P><P></P><P>but there is a missing ] after Cust Id</P></BODY></HTML> Tue, 08 Sep 2015 23:03:07 GMT maxgro 2015-09-08T23:03:07Z Set Analysis Expression https://community.qlik.com/t5/QlikView/Set-Analysis-Expression/m-p/993930#M338381 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>Can any body explain me what is the meaning of below expression.means,how it works</P><P></P><P>=SUM({$&lt;[Year]={'2015'}&gt;-&lt;C1={'Blocked'}&gt;-&lt;D1={'Blocked'}&gt;+</P><P>&lt;[Cust Id={'43524'}&gt;} [Sales Vol])</P><P></P><P>Regards,</P><P>Vijeta</P></BODY></HTML> Tue, 08 Sep 2015 12:17:43 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-Expression/m-p/993930#M338381 vijetas42 2015-09-08T12:17:43Z Re: Set Analysis Expression https://community.qlik.com/t5/QlikView/Set-Analysis-Expression/m-p/993931#M338382 <HTML><HEAD></HEAD><BODY><P>I think</P><P>sum of sales vol for year 2015, excluding c1 blocked, excluding d1 blocked, adding cust id 43524</P><P></P><P>but there is a missing ] after Cust Id</P></BODY></HTML> Tue, 08 Sep 2015 23:03:07 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-Expression/m-p/993931#M338382 maxgro 2015-09-08T23:03:07Z