topic Re: Problem with total in Pivot Table in QlikView https://community.qlik.com/t5/QlikView/Problem-with-total-in-Pivot-Table/m-p/841139#M998176 <HTML><HEAD></HEAD><BODY><P>Can go through the below thread, will be help full to understand .</P><P></P><P><A href="https://community.qlik.com/thread/36007">Expression total vs Sum total</A></P></BODY></HTML> Mon, 29 Jun 2015 09:32:44 GMT vardhancse 2015-06-29T09:32:44Z Problem with total in Pivot Table https://community.qlik.com/t5/QlikView/Problem-with-total-in-Pivot-Table/m-p/841134#M998169 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a problem when showing total sales.</P><P>The problem is there is a gap between total in data source with total in qlikview application, but the gap isn't significant (about 0.01). It must be the same between total from data source and total in qlikview application, because in qlikview&nbsp; i load the same data source.</P><P>Are there any possibilities when i load the data from data source, the data is corrupt ? Or there is a problem with my qlikview ?</P><P></P><P>Sorry can't give the detail of my application.</P><P>Really appreciate your help. Thanks <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /> </P></BODY></HTML> Mon, 29 Jun 2015 08:39:09 GMT https://community.qlik.com/t5/QlikView/Problem-with-total-in-Pivot-Table/m-p/841134#M998169 2015-06-29T08:39:09Z Re: Problem with total in Pivot Table https://community.qlik.com/t5/QlikView/Problem-with-total-in-Pivot-Table/m-p/841135#M998170 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>The total in qlikview will be different from the total what we see from source.</P><P></P><P>In qlikview it will be expression total</P></BODY></HTML> Mon, 29 Jun 2015 08:44:10 GMT https://community.qlik.com/t5/QlikView/Problem-with-total-in-Pivot-Table/m-p/841135#M998170 vardhancse 2015-06-29T08:44:10Z Re: Problem with total in Pivot Table https://community.qlik.com/t5/QlikView/Problem-with-total-in-Pivot-Table/m-p/841136#M998171 <HTML><HEAD></HEAD><BODY><P>Hi Sasi,</P><P></P><P>Thanks for your reply, i mean i calculate the total with sum(sales) in qlikview, when i compare it with the total sales from data source there is a little gap.</P><P></P><P>Thanks <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /> </P></BODY></HTML> Mon, 29 Jun 2015 08:48:41 GMT https://community.qlik.com/t5/QlikView/Problem-with-total-in-Pivot-Table/m-p/841136#M998171 2015-06-29T08:48:41Z Re: Problem with total in Pivot Table https://community.qlik.com/t5/QlikView/Problem-with-total-in-Pivot-Table/m-p/841137#M998173 <HTML><HEAD></HEAD><BODY><P>yes, in qlikview that gap will come as it is expression total</P></BODY></HTML> Mon, 29 Jun 2015 09:04:12 GMT https://community.qlik.com/t5/QlikView/Problem-with-total-in-Pivot-Table/m-p/841137#M998173 vardhancse 2015-06-29T09:04:12Z Re: Problem with total in Pivot Table https://community.qlik.com/t5/QlikView/Problem-with-total-in-Pivot-Table/m-p/841138#M998174 <HTML><HEAD></HEAD><BODY><P>Can you tell me what is expression total mean Sasi ?</P><P>Sorry, i dont get the idea.</P><P></P><P>Thanks.</P></BODY></HTML> Mon, 29 Jun 2015 09:19:57 GMT https://community.qlik.com/t5/QlikView/Problem-with-total-in-Pivot-Table/m-p/841138#M998174 2015-06-29T09:19:57Z Re: Problem with total in Pivot Table https://community.qlik.com/t5/QlikView/Problem-with-total-in-Pivot-Table/m-p/841139#M998176 <HTML><HEAD></HEAD><BODY><P>Can go through the below thread, will be help full to understand .</P><P></P><P><A href="https://community.qlik.com/thread/36007">Expression total vs Sum total</A></P></BODY></HTML> Mon, 29 Jun 2015 09:32:44 GMT https://community.qlik.com/t5/QlikView/Problem-with-total-in-Pivot-Table/m-p/841139#M998176 vardhancse 2015-06-29T09:32:44Z Re: Problem with total in Pivot Table https://community.qlik.com/t5/QlikView/Problem-with-total-in-Pivot-Table/m-p/841140#M998178 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>It should exactly match, if you are doing rounding off or applying number format in Number tab or something else then you will get this type of small mismatch. </P><P></P><P>Regards,</P><P>Jagan.</P></BODY></HTML> Mon, 29 Jun 2015 10:25:24 GMT https://community.qlik.com/t5/QlikView/Problem-with-total-in-Pivot-Table/m-p/841140#M998178 jagan 2015-06-29T10:25:24Z Re: Problem with total in Pivot Table https://community.qlik.com/t5/QlikView/Problem-with-total-in-Pivot-Table/m-p/841141#M998179 <HTML><HEAD></HEAD><BODY><P>Hi Jagan,</P><P></P><P>Yes, ,i also think that it should be match. I don't put any rounding or number format in number tab.</P><P>The difference is about 0.01 only. Do you have any idea Jagan ?</P><P></P><P>Thanks</P></BODY></HTML> Mon, 29 Jun 2015 10:36:13 GMT https://community.qlik.com/t5/QlikView/Problem-with-total-in-Pivot-Table/m-p/841141#M998179 2015-06-29T10:36:13Z Re: Problem with total in Pivot Table https://community.qlik.com/t5/QlikView/Problem-with-total-in-Pivot-Table/m-p/841142#M998181 <HTML><HEAD></HEAD><BODY><P>Make sure your number format as "Expression Default" to match the total with data source.</P></BODY></HTML> Mon, 29 Jun 2015 10:53:07 GMT https://community.qlik.com/t5/QlikView/Problem-with-total-in-Pivot-Table/m-p/841142#M998181 2015-06-29T10:53:07Z Re: Problem with total in Pivot Table https://community.qlik.com/t5/QlikView/Problem-with-total-in-Pivot-Table/m-p/841143#M998183 <HTML><HEAD></HEAD><BODY><P>If you share the application or data then it would easier to analyse, otherwise it is difficult to identify.</P><P></P><P>Regards,</P><P>Jagan.</P></BODY></HTML> Mon, 29 Jun 2015 14:55:44 GMT https://community.qlik.com/t5/QlikView/Problem-with-total-in-Pivot-Table/m-p/841143#M998183 jagan 2015-06-29T14:55:44Z