topic Re: Error in Totals in QlikView https://community.qlik.com/t5/QlikView/Error-in-Totals/m-p/1389654#M459465 <HTML><HEAD></HEAD><BODY><P>Is this a straight table? If it is, then try to enable 'Sum of Rows' for total mode on the expressions tab of chart properties</P></BODY></HTML> Thu, 21 Sep 2017 11:12:19 GMT sunny_talwar 2017-09-21T11:12:19Z Error in Totals https://community.qlik.com/t5/QlikView/Error-in-Totals/m-p/1389653#M459464 <HTML><HEAD></HEAD><BODY><P>Hello All,</P><P></P><P>I am facing an issue with Qlikview report. In qlikview report the total value is different and in exported data total value is showing different. Please check the screen below for better understand and suggest me to resolve the issue.</P><P></P><P><IMG alt="ErrorCalculation.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/177274_ErrorCalculation.png" style="height: 267px; width: 620px;" /></P><P>Regards,</P><P>Ram</P></BODY></HTML> Thu, 21 Sep 2017 11:11:02 GMT https://community.qlik.com/t5/QlikView/Error-in-Totals/m-p/1389653#M459464 Anonymous 2017-09-21T11:11:02Z Re: Error in Totals https://community.qlik.com/t5/QlikView/Error-in-Totals/m-p/1389654#M459465 <HTML><HEAD></HEAD><BODY><P>Is this a straight table? If it is, then try to enable 'Sum of Rows' for total mode on the expressions tab of chart properties</P></BODY></HTML> Thu, 21 Sep 2017 11:12:19 GMT https://community.qlik.com/t5/QlikView/Error-in-Totals/m-p/1389654#M459465 sunny_talwar 2017-09-21T11:12:19Z Re: Error in Totals https://community.qlik.com/t5/QlikView/Error-in-Totals/m-p/1389655#M459466 <HTML><HEAD></HEAD><BODY><P>Hi Sunny,</P><P></P><P>Thanks for reply,</P><P>It is straight table, I tried that option but not giving correct count. Can you suggest any other ways to get the correct count</P><P></P><P>Regards,</P><P>Ram</P></BODY></HTML> Thu, 21 Sep 2017 11:21:41 GMT https://community.qlik.com/t5/QlikView/Error-in-Totals/m-p/1389655#M459466 Anonymous 2017-09-21T11:21:41Z Re: Error in Totals https://community.qlik.com/t5/QlikView/Error-in-Totals/m-p/1389656#M459467 <HTML><HEAD></HEAD><BODY><P>You can try Sum(Aggr(YourExpression, YourChartDimensions)), but I would expect it to give the same value as your Sum of Rows... would you be able to share a sample?</P></BODY></HTML> Thu, 21 Sep 2017 11:23:41 GMT https://community.qlik.com/t5/QlikView/Error-in-Totals/m-p/1389656#M459467 sunny_talwar 2017-09-21T11:23:41Z Re: Error in Totals https://community.qlik.com/t5/QlikView/Error-in-Totals/m-p/1389657#M459468 <HTML><HEAD></HEAD><BODY><P>Thanks Sunny for reply.</P><P></P><P>I tried it, still same error in the count.</P><P></P><P>Regards,</P><P>Ram</P></BODY></HTML> Mon, 25 Sep 2017 08:20:30 GMT https://community.qlik.com/t5/QlikView/Error-in-Totals/m-p/1389657#M459468 Anonymous 2017-09-25T08:20:30Z Re: Error in Totals https://community.qlik.com/t5/QlikView/Error-in-Totals/m-p/1389658#M459469 <HTML><HEAD></HEAD><BODY><P>Would you be able to share a sample?</P></BODY></HTML> Mon, 25 Sep 2017 08:24:25 GMT https://community.qlik.com/t5/QlikView/Error-in-Totals/m-p/1389658#M459469 sunny_talwar 2017-09-25T08:24:25Z Re: Error in Totals https://community.qlik.com/t5/QlikView/Error-in-Totals/m-p/1389659#M459470 <HTML><HEAD></HEAD><BODY><P>Issue resolve. Please close this topic</P></BODY></HTML> Mon, 25 Sep 2017 09:32:30 GMT https://community.qlik.com/t5/QlikView/Error-in-Totals/m-p/1389659#M459470 Anonymous 2017-09-25T09:32:30Z Re: Error in Totals https://community.qlik.com/t5/QlikView/Error-in-Totals/m-p/1389660#M459471 <HTML><HEAD></HEAD><BODY><P>Select the answer as correct which helps you.</P></BODY></HTML> Mon, 25 Sep 2017 09:35:06 GMT https://community.qlik.com/t5/QlikView/Error-in-Totals/m-p/1389660#M459471 PrashantSangle 2017-09-25T09:35:06Z Re: Error in Totals https://community.qlik.com/t5/QlikView/Error-in-Totals/m-p/1389661#M459472 <HTML><HEAD></HEAD><BODY><P>this issue yet to resolve, I am waiting more suggestions.</P><P></P><P>Regards,</P><P>Ram</P></BODY></HTML> Mon, 25 Sep 2017 09:54:45 GMT https://community.qlik.com/t5/QlikView/Error-in-Totals/m-p/1389661#M459472 Anonymous 2017-09-25T09:54:45Z Re: Error in Totals https://community.qlik.com/t5/QlikView/Error-in-Totals/m-p/1389662#M459473 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>As per your earlier response , You said</P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG><BR /></STRONG></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>Issue resolve. Please close this topic</STRONG>.</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">If not please attached qvw.</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Regards,</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Prashant Sangle<BR /></SPAN></P></BODY></HTML> Mon, 25 Sep 2017 09:58:35 GMT https://community.qlik.com/t5/QlikView/Error-in-Totals/m-p/1389662#M459473 PrashantSangle 2017-09-25T09:58:35Z Re: Error in Totals https://community.qlik.com/t5/QlikView/Error-in-Totals/m-p/1389663#M459474 <HTML><HEAD></HEAD><BODY><P>Hi Shraddha,</P><P></P><P>Thanks for your suggestion.The problem with Tnsnames and I re created Tnanames in the respective directory and the issue resolved.</P><P>@Team , Please close the topic.</P><P></P><P>Regards,</P><P>Ram</P></BODY></HTML> Wed, 27 Sep 2017 04:31:48 GMT https://community.qlik.com/t5/QlikView/Error-in-Totals/m-p/1389663#M459474 Anonymous 2017-09-27T04:31:48Z Re: Error in Totals https://community.qlik.com/t5/QlikView/Error-in-Totals/m-p/1389664#M459475 <HTML><HEAD></HEAD><BODY><P>Hi Sunny,</P><P></P><P>Do we have option to attach file? I found insert image,video and link. Suggest me</P><P></P><P>Regards,</P><P>Ram</P></BODY></HTML> Thu, 28 Sep 2017 07:21:09 GMT https://community.qlik.com/t5/QlikView/Error-in-Totals/m-p/1389664#M459475 Anonymous 2017-09-28T07:21:09Z Re: Error in Totals https://community.qlik.com/t5/QlikView/Error-in-Totals/m-p/1389665#M459476 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>click on advance editor on right top of reply window.</P><P></P><P>Regards,</P></BODY></HTML> Thu, 28 Sep 2017 07:34:48 GMT https://community.qlik.com/t5/QlikView/Error-in-Totals/m-p/1389665#M459476 PrashantSangle 2017-09-28T07:34:48Z Re: Error in Totals https://community.qlik.com/t5/QlikView/Error-in-Totals/m-p/1389666#M459477 <HTML><HEAD></HEAD><BODY><P><A href="https://community.qlik.com/docs/DOC-16454">Uploading a Sample</A></P></BODY></HTML> Thu, 28 Sep 2017 08:19:45 GMT https://community.qlik.com/t5/QlikView/Error-in-Totals/m-p/1389666#M459477 sunny_talwar 2017-09-28T08:19:45Z Re: Error in Totals https://community.qlik.com/t5/QlikView/Error-in-Totals/m-p/1389667#M459478 <HTML><HEAD></HEAD><BODY><P>only you can close this thread</P><P>you will have to close the thread by marking the correct answer.</P><P></P><P>Note: the option for marking correct and helpful answers is not showing off if you watch this thread through your Inbox</P><P></P><P>hope this helps</P></BODY></HTML> Thu, 28 Sep 2017 08:30:42 GMT https://community.qlik.com/t5/QlikView/Error-in-Totals/m-p/1389667#M459478 Frank_Hartmann 2017-09-28T08:30:42Z Re: Error in Totals https://community.qlik.com/t5/QlikView/Error-in-Totals/m-p/1389668#M459479 <HTML><HEAD></HEAD><BODY><P>Hi Frank,</P><P></P><P>Do you want me to close this topic without resolving my query.?</P><P></P><P>Regards,</P><P>Ram</P></BODY></HTML> Thu, 28 Sep 2017 08:46:01 GMT https://community.qlik.com/t5/QlikView/Error-in-Totals/m-p/1389668#M459479 Anonymous 2017-09-28T08:46:01Z Re: Error in Totals https://community.qlik.com/t5/QlikView/Error-in-Totals/m-p/1389669#M459480 <HTML><HEAD></HEAD><BODY><P>????</P><P></P><P><IMG alt="Unbenannt.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/177945_Unbenannt.png" style="height: 171px; width: 620px;" /></P></BODY></HTML> Thu, 28 Sep 2017 08:52:47 GMT https://community.qlik.com/t5/QlikView/Error-in-Totals/m-p/1389669#M459480 Frank_Hartmann 2017-09-28T08:52:47Z Re: Error in Totals https://community.qlik.com/t5/QlikView/Error-in-Totals/m-p/1389670#M459481 <HTML><HEAD></HEAD><BODY><P>Hi Frank,</P><P> Thought was close to different topic,<SPAN style="font-size: 13.3333px;">By mistake I typed in this topic.</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Regards,</SPAN></P><P><SPAN style="font-size: 13.3333px;">Ram</SPAN></P></BODY></HTML> Thu, 28 Sep 2017 09:03:26 GMT https://community.qlik.com/t5/QlikView/Error-in-Totals/m-p/1389670#M459481 Anonymous 2017-09-28T09:03:26Z Re: Error in Totals https://community.qlik.com/t5/QlikView/Error-in-Totals/m-p/1389671#M459482 <HTML><HEAD></HEAD><BODY><P>Well you said twice in this thread that topic is closed.</P><P></P><P>Nevertheless, Share your app to help you in better way.</P><P></P><P>Regards, </P></BODY></HTML> Thu, 28 Sep 2017 09:10:00 GMT https://community.qlik.com/t5/QlikView/Error-in-Totals/m-p/1389671#M459482 PrashantSangle 2017-09-28T09:10:00Z