topic Re: Set Analysis Query in QlikView https://community.qlik.com/t5/QlikView/Set-Analysis-Query/m-p/869601#M656465 <HTML><HEAD></HEAD><BODY><P><A href="http://">http://</A> </P><P></P><P>Please refer the attached excel file in which Raw Data is available as well as outpur required is also available.</P></BODY></HTML> Thu, 11 Jun 2015 08:55:22 GMT suresh_rawat 2015-06-11T08:55:22Z Set Analysis Query https://community.qlik.com/t5/QlikView/Set-Analysis-Query/m-p/869599#M656463 <HTML><HEAD></HEAD><BODY><P><BR />Hi everyone,</P><P></P><P>Can you please tell me how to write this expression in Set Analysis.</P><P></P><P><STRONG>Expression :</STRONG> =sum(total &lt;State&gt; Competitor_Data)</P><P></P><P>In Set Analysis..How????</P></BODY></HTML> Thu, 11 Jun 2015 07:11:04 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-Query/m-p/869599#M656463 suresh_rawat 2015-06-11T07:11:04Z Re: Set Analysis Query https://community.qlik.com/t5/QlikView/Set-Analysis-Query/m-p/869600#M656464 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Try like this:</P><P>=Sum({&lt;State={"StateName"}&gt;}Total Competitor_Data)</P></BODY></HTML> Thu, 11 Jun 2015 07:48:37 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-Query/m-p/869600#M656464 2015-06-11T07:48:37Z Re: Set Analysis Query https://community.qlik.com/t5/QlikView/Set-Analysis-Query/m-p/869601#M656465 <HTML><HEAD></HEAD><BODY><P><A href="http://">http://</A> </P><P></P><P>Please refer the attached excel file in which Raw Data is available as well as outpur required is also available.</P></BODY></HTML> Thu, 11 Jun 2015 08:55:22 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-Query/m-p/869601#M656465 suresh_rawat 2015-06-11T08:55:22Z