topic Re: question (Total) in QlikView https://community.qlik.com/t5/QlikView/question-Total/m-p/1391873#M423098 <HTML><HEAD></HEAD><BODY><P><IMG alt="test_20.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/173256_test_20.png" style="height: 286px; width: 620px;" /></P></BODY></HTML> Sat, 12 Aug 2017 06:00:13 GMT ecolomer 2017-08-12T06:00:13Z question (Total) https://community.qlik.com/t5/QlikView/question-Total/m-p/1391870#M423095 <HTML><HEAD></HEAD><BODY><P>I have done a calculation on fixed value after loading tow tables of which this cell was considered as an absolute cell reference.But once I brought this in to a pivot table, total doesn't appear as 100%. I may present my case as below:</P><P></P><P>Class_Code&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Amount&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Percentage (Taken through a formula)</P><P>MC&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 500&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10%</P><P>FR&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 40%</P><P>TC&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20%</P><P>M3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1500&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 30%</P><P>Total&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="color: #ff0000;">100%&nbsp; (Once data are loaded in pivot table, total % as 100 is not appeared). </SPAN></P><P><SPAN style="color: #000000;">Please explain how this will be obtained</SPAN></P><P><SPAN style="color: #000000;"><BR /></SPAN></P><P><SPAN style="color: #000000;"><BR /></SPAN></P><P><SPAN style="color: #000000;">Thanks</SPAN></P><P><SPAN style="color: #000000;"><BR /></SPAN></P><P><SPAN style="color: #000000;">Neville</SPAN></P></BODY></HTML> Sat, 12 Aug 2017 03:05:22 GMT https://community.qlik.com/t5/QlikView/question-Total/m-p/1391870#M423095 nevilledhamsiri 2017-08-12T03:05:22Z Re: question (Total) https://community.qlik.com/t5/QlikView/question-Total/m-p/1391871#M423096 <HTML><HEAD></HEAD><BODY><P>Is this you need</P><P><IMG alt="test_20.png" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/173255_test_20.png" style="height: 254px; width: 620px;" /></P></BODY></HTML> Sat, 12 Aug 2017 05:35:56 GMT https://community.qlik.com/t5/QlikView/question-Total/m-p/1391871#M423096 ecolomer 2017-08-12T05:35:56Z Re: question (Total) https://community.qlik.com/t5/QlikView/question-Total/m-p/1391872#M423097 <HTML><HEAD></HEAD><BODY><P>I need 100% to appear in last row of percentage column!</P></BODY></HTML> Sat, 12 Aug 2017 05:57:44 GMT https://community.qlik.com/t5/QlikView/question-Total/m-p/1391872#M423097 nevilledhamsiri 2017-08-12T05:57:44Z Re: question (Total) https://community.qlik.com/t5/QlikView/question-Total/m-p/1391873#M423098 <HTML><HEAD></HEAD><BODY><P><IMG alt="test_20.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/173256_test_20.png" style="height: 286px; width: 620px;" /></P></BODY></HTML> Sat, 12 Aug 2017 06:00:13 GMT https://community.qlik.com/t5/QlikView/question-Total/m-p/1391873#M423098 ecolomer 2017-08-12T06:00:13Z