topic Re: Sum of Rows in QlikView https://community.qlik.com/t5/QlikView/Sum-of-Rows/m-p/1378620#M817467 <HTML><HEAD></HEAD><BODY><P>Dimension in your straight table chart</P></BODY></HTML> Fri, 25 Aug 2017 12:42:58 GMT sunny_talwar 2017-08-25T12:42:58Z Sum of Rows https://community.qlik.com/t5/QlikView/Sum-of-Rows/m-p/1378611#M817458 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>My expression is:</P><P>Sum({&lt;LinkDate={'&lt;=$(vDate)'}&gt;}TSL)*only({&lt;Date_Currency={'$(vMaxCurrencyDate)'}&gt;}Rate_Currency1)</P><P>and I am&nbsp; not getting sum of expression.</P><P><SPAN style="font-size: 13.3333px;">vDate is DataIland Date,</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">only({&lt;Date_Currency={'$(vMaxCurrencyDate)'}&gt;}Rate_Currency1)</SPAN></P><P><SPAN style="font-size: 13.3333px;">is for selected <SPAN style="font-size: 13.3333px;">Date_Currency and by default should show rate of max of <SPAN style="font-size: 13.3333px;">Date_Currency.</SPAN></SPAN><BR /></SPAN></P><P></P><P>Kindly suggest change in my expression.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Sum-of-Rows/m-p/1378611#M817458 rkspareek1992 2020-11-25T16:16:04Z Re: Sum of Rows https://community.qlik.com/t5/QlikView/Sum-of-Rows/m-p/1378612#M817459 <HTML><HEAD></HEAD><BODY><P>You mean you are unable to get the correct totals or you are not getting a number on any row?</P></BODY></HTML> Thu, 24 Aug 2017 12:22:33 GMT https://community.qlik.com/t5/QlikView/Sum-of-Rows/m-p/1378612#M817459 sunny_talwar 2017-08-24T12:22:33Z Re: Sum of Rows https://community.qlik.com/t5/QlikView/Sum-of-Rows/m-p/1378613#M817460 <HTML><HEAD></HEAD><BODY><P>I am not getting total.</P><P></P><P><IMG alt="Capture2.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/174525_Capture2.PNG" style="height: auto;" /></P></BODY></HTML> Thu, 24 Aug 2017 12:25:47 GMT https://community.qlik.com/t5/QlikView/Sum-of-Rows/m-p/1378613#M817460 rkspareek1992 2017-08-24T12:25:47Z Re: Sum of Rows https://community.qlik.com/t5/QlikView/Sum-of-Rows/m-p/1378614#M817461 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><STRONG>Sum(Aggr(</STRONG><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>Sum({&lt;LinkDate={'&lt;=$(vDate)'}&gt;}TSL)*only({&lt;Date_Currency={'$(vMaxCurrencyDate)'}&gt;}Rate_Currency1), YourChartDimensionsHere))</STRONG></SPAN></P></BODY></HTML> Thu, 24 Aug 2017 12:29:18 GMT https://community.qlik.com/t5/QlikView/Sum-of-Rows/m-p/1378614#M817461 sunny_talwar 2017-08-24T12:29:18Z Re: Sum of Rows https://community.qlik.com/t5/QlikView/Sum-of-Rows/m-p/1378615#M817462 <HTML><HEAD></HEAD><BODY><P>Its not working....</P><P></P><P>Showing 0 as total.</P></BODY></HTML> Thu, 24 Aug 2017 12:59:42 GMT https://community.qlik.com/t5/QlikView/Sum-of-Rows/m-p/1378615#M817462 rkspareek1992 2017-08-24T12:59:42Z Re: Sum of Rows https://community.qlik.com/t5/QlikView/Sum-of-Rows/m-p/1378616#M817463 <HTML><HEAD></HEAD><BODY><P>Is this a straight table? Set Total Mode to Sum of rows on the expression tab to see if that works</P></BODY></HTML> Thu, 24 Aug 2017 13:12:27 GMT https://community.qlik.com/t5/QlikView/Sum-of-Rows/m-p/1378616#M817463 sunny_talwar 2017-08-24T13:12:27Z Re: Sum of Rows https://community.qlik.com/t5/QlikView/Sum-of-Rows/m-p/1378617#M817464 <HTML><HEAD></HEAD><BODY><P>Currently I am using straight table, but&nbsp; I want to&nbsp; use this expression in qliksense charts.</P><P></P><P>I have tried in&nbsp; expression&nbsp; tab by selection sum of&nbsp; rows, then its&nbsp; showing, But I wants same numbers in expression total.</P><P></P><P>Kindly suggest.</P></BODY></HTML> Fri, 25 Aug 2017 04:21:54 GMT https://community.qlik.com/t5/QlikView/Sum-of-Rows/m-p/1378617#M817464 rkspareek1992 2017-08-25T04:21:54Z Re: Sum of Rows https://community.qlik.com/t5/QlikView/Sum-of-Rows/m-p/1378618#M817465 <HTML><HEAD></HEAD><BODY><P>What all are your dimensions?</P></BODY></HTML> Fri, 25 Aug 2017 10:11:53 GMT https://community.qlik.com/t5/QlikView/Sum-of-Rows/m-p/1378618#M817465 sunny_talwar 2017-08-25T10:11:53Z Re: Sum of Rows https://community.qlik.com/t5/QlikView/Sum-of-Rows/m-p/1378619#M817466 <HTML><HEAD></HEAD><BODY><P>I can select any dimension for ex. Co.Code, Plant, Country etc.</P></BODY></HTML> Fri, 25 Aug 2017 11:34:56 GMT https://community.qlik.com/t5/QlikView/Sum-of-Rows/m-p/1378619#M817466 rkspareek1992 2017-08-25T11:34:56Z Re: Sum of Rows https://community.qlik.com/t5/QlikView/Sum-of-Rows/m-p/1378620#M817467 <HTML><HEAD></HEAD><BODY><P>Dimension in your straight table chart</P></BODY></HTML> Fri, 25 Aug 2017 12:42:58 GMT https://community.qlik.com/t5/QlikView/Sum-of-Rows/m-p/1378620#M817467 sunny_talwar 2017-08-25T12:42:58Z Re: Sum of Rows https://community.qlik.com/t5/QlikView/Sum-of-Rows/m-p/1378621#M817468 <HTML><HEAD></HEAD><BODY><P>I have just one dimension in straight table is RBUKRS.</P></BODY></HTML> Sat, 26 Aug 2017 10:29:15 GMT https://community.qlik.com/t5/QlikView/Sum-of-Rows/m-p/1378621#M817468 rkspareek1992 2017-08-26T10:29:15Z Re: Sum of Rows https://community.qlik.com/t5/QlikView/Sum-of-Rows/m-p/1378622#M817469 <HTML><HEAD></HEAD><BODY><P>Can you try this</P><P></P><P><STRONG>Sum(Aggr(Sum({&lt;LinkDate={'&lt;=$(vDate)'}&gt;}TSL)*only({&lt;Date_Currency={'$(vMaxCurrencyDate)'}&gt;}Rate_Currency1), <SPAN style="color: #ff0000;">RBUKRS</SPAN>))</STRONG></P></BODY></HTML> Sat, 26 Aug 2017 10:59:59 GMT https://community.qlik.com/t5/QlikView/Sum-of-Rows/m-p/1378622#M817469 sunny_talwar 2017-08-26T10:59:59Z Re: Sum of Rows https://community.qlik.com/t5/QlikView/Sum-of-Rows/m-p/1378623#M817470 <HTML><HEAD></HEAD><BODY><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Hi Sunny,</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">I have already tried, but unable to get sum.</P></BODY></HTML> Sat, 26 Aug 2017 11:08:14 GMT https://community.qlik.com/t5/QlikView/Sum-of-Rows/m-p/1378623#M817470 rkspareek1992 2017-08-26T11:08:14Z Re: Sum of Rows https://community.qlik.com/t5/QlikView/Sum-of-Rows/m-p/1378624#M817471 <HTML><HEAD></HEAD><BODY><P>Would you be able to share a sample?</P></BODY></HTML> Sat, 26 Aug 2017 11:28:11 GMT https://community.qlik.com/t5/QlikView/Sum-of-Rows/m-p/1378624#M817471 sunny_talwar 2017-08-26T11:28:11Z Re: Sum of Rows https://community.qlik.com/t5/QlikView/Sum-of-Rows/m-p/1378625#M817472 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">I am using pivot table and unable&nbsp; to sum values..</SPAN></P></BODY></HTML> Mon, 04 Sep 2017 10:10:54 GMT https://community.qlik.com/t5/QlikView/Sum-of-Rows/m-p/1378625#M817472 rkspareek1992 2017-09-04T10:10:54Z