topic Re: Set analytics. in QlikView https://community.qlik.com/t5/QlikView/Set-analytics/m-p/570778#M212682 <HTML><HEAD></HEAD><BODY><P>Thank you!! Jagan!!</P></BODY></HTML> Tue, 29 Apr 2014 07:19:18 GMT 2014-04-29T07:19:18Z Set analytics. https://community.qlik.com/t5/QlikView/Set-analytics/m-p/570775#M212679 <HTML><HEAD></HEAD><BODY><P>HI, ALL.</P><P></P><P>I'm using the set analytics.</P><P>now table shows each sum like qvw file.</P><P>but, I wanna showing sum of each same column(as col1)</P><P>so far I used 'set analytics','aggr', 'rangesum'...</P><P>I don't know how to resolve this...</P><P></P><P>result I want is </P><P>month&nbsp;&nbsp;&nbsp;&nbsp; col1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sum(col2)</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; a&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 63</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; b&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 63</P><P>2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; b&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 47</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; c&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 47</P><P>3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; c&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 51</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; d&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 51</P><P>4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; d&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 27</P><P></P><P>thanks any opinions.</P></BODY></HTML> Tue, 29 Apr 2014 06:54:53 GMT https://community.qlik.com/t5/QlikView/Set-analytics/m-p/570775#M212679 2014-04-29T06:54:53Z Re: Set analytics. https://community.qlik.com/t5/QlikView/Set-analytics/m-p/570776#M212680 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Try this expression</P><P></P><P>=sum(TOTAL&lt;month&gt;col2)</P><P></P><P>Regards,</P><P>Jagan.</P></BODY></HTML> Tue, 29 Apr 2014 07:00:27 GMT https://community.qlik.com/t5/QlikView/Set-analytics/m-p/570776#M212680 jagan 2014-04-29T07:00:27Z Re: Set analytics. https://community.qlik.com/t5/QlikView/Set-analytics/m-p/570777#M212681 <HTML><HEAD></HEAD><BODY><P>instead of sum(col2) use below expression as.</P><P></P><P>SUM(TOTAL &lt;month&gt; col2)</P></BODY></HTML> Tue, 29 Apr 2014 07:10:14 GMT https://community.qlik.com/t5/QlikView/Set-analytics/m-p/570777#M212681 MK_QSL 2014-04-29T07:10:14Z Re: Set analytics. https://community.qlik.com/t5/QlikView/Set-analytics/m-p/570778#M212682 <HTML><HEAD></HEAD><BODY><P>Thank you!! Jagan!!</P></BODY></HTML> Tue, 29 Apr 2014 07:19:18 GMT https://community.qlik.com/t5/QlikView/Set-analytics/m-p/570778#M212682 2014-04-29T07:19:18Z