topic pivot in QlikView https://community.qlik.com/t5/QlikView/pivot/m-p/822958#M1039625 <HTML><HEAD></HEAD><BODY><P style="font-weight: inherit; font-style: inherit; font-size: 13.3333339691162px; font-family: inherit; color: #3d3d3d;">I have my pivot table in this form</P><P class="jive-thread-reply-btn" style="margin-top: 26px; margin-bottom: -10px; font-size: 0.9em; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"> <IMG class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/73318_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" />&nbsp; </P><P class="jive-thread-reply-btn" style="margin-top: 26px; margin-bottom: -10px; font-size: 0.9em; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">But I need it in this form</P><P>&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;&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;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" height="149" style="width: 481px; height: 1px;"><TBODY><TR><TD colspan="1">Loyality</TD><TD colspan="1">NoLoyality</TD><TD colspan="1">Total</TD><TD colspan="1">Loyality</TD><TD colspan="1">NoLoyality</TD><TD colspan="1">Total</TD></TR><TR style="height: 15.0pt;"><TD class="xl79" height="20" style="height: 15.0pt; width: 60pt;" width="80">Perc</TD><TD class="xl79" style="border-left: none; width: 68pt;" width="91">Perc</TD><TD class="xl79" style="border-left: none; width: 58pt;" width="77">Sale</TD><TD class="xl79" style="border-left: none; width: 57pt;" width="76">Perc</TD><TD class="xl79" style="border-left: none; width: 59pt;" width="78">Perc</TD><TD class="xl79" style="border-left: none; width: 58pt;" width="77">Sale</TD></TR><TR style="height: 15.0pt;"><TD class="xl74" height="20" style="height: 15.0pt; border-top: none;">40%</TD><TD class="xl74" style="border-top: none; border-left: none;">60%</TD><TD class="xl73" style="border-top: none; border-left: none;">558,588</TD><TD class="xl74" style="border-top: none; border-left: none;">42%</TD><TD class="xl74" style="border-top: none; border-left: none;">58%</TD><TD class="xl73" style="border-top: none; border-left: none;">603,816</TD></TR><TR style="height: 15.0pt;"><TD class="xl76" height="20" style="height: 15.0pt; border-top: none;">44%</TD><TD class="xl76" style="border-top: none; border-left: none;">56%</TD><TD class="xl75" style="border-top: none; border-left: none;">145,166</TD><TD class="xl76" style="border-top: none; border-left: none;">45%</TD><TD class="xl76" style="border-top: none; border-left: none;">55%</TD><TD class="xl75" style="border-top: none; border-left: none;">165,081</TD></TR><TR style="height: 15.0pt;"><TD class="xl78" height="20" style="height: 15.0pt; border-top: none;">50%</TD><TD class="xl78" style="border-top: none; border-left: none;">50%</TD><TD class="xl77" style="border-top: none; border-left: none;">38,166</TD><TD class="xl78" style="border-top: none; border-left: none;">50%</TD><TD class="xl78" style="border-top: none; border-left: none;">50%</TD><TD class="xl77" style="border-top: none; border-left: none;">51,720</TD></TR><TR style="height: 15.0pt;"><TD class="xl74" height="20" style="height: 15.0pt; border-top: none;">53%</TD><TD class="xl74" style="border-top: none; border-left: none;">47%</TD><TD class="xl73" style="border-top: none; border-left: none;">11,986</TD><TD class="xl74" style="border-top: none; border-left: none;">53%</TD><TD class="xl74" style="border-top: none; border-left: none;">47%</TD><TD class="xl73" style="border-top: none; border-left: none;">14,053</TD></TR></TBODY></TABLE><P></P><P>Total comes using show partial sum, but it shows in % as Perc is in %, but I want it in numbers.</P><P></P><P>Plz solve this problem</P><P>Thanking You</P></BODY></HTML> Fri, 12 Dec 2014 10:55:31 GMT tyagishaila 2014-12-12T10:55:31Z pivot https://community.qlik.com/t5/QlikView/pivot/m-p/822958#M1039625 <HTML><HEAD></HEAD><BODY><P style="font-weight: inherit; font-style: inherit; font-size: 13.3333339691162px; font-family: inherit; color: #3d3d3d;">I have my pivot table in this form</P><P class="jive-thread-reply-btn" style="margin-top: 26px; margin-bottom: -10px; font-size: 0.9em; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"> <IMG class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/73318_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" />&nbsp; </P><P class="jive-thread-reply-btn" style="margin-top: 26px; margin-bottom: -10px; font-size: 0.9em; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">But I need it in this form</P><P>&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;&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;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" height="149" style="width: 481px; height: 1px;"><TBODY><TR><TD colspan="1">Loyality</TD><TD colspan="1">NoLoyality</TD><TD colspan="1">Total</TD><TD colspan="1">Loyality</TD><TD colspan="1">NoLoyality</TD><TD colspan="1">Total</TD></TR><TR style="height: 15.0pt;"><TD class="xl79" height="20" style="height: 15.0pt; width: 60pt;" width="80">Perc</TD><TD class="xl79" style="border-left: none; width: 68pt;" width="91">Perc</TD><TD class="xl79" style="border-left: none; width: 58pt;" width="77">Sale</TD><TD class="xl79" style="border-left: none; width: 57pt;" width="76">Perc</TD><TD class="xl79" style="border-left: none; width: 59pt;" width="78">Perc</TD><TD class="xl79" style="border-left: none; width: 58pt;" width="77">Sale</TD></TR><TR style="height: 15.0pt;"><TD class="xl74" height="20" style="height: 15.0pt; border-top: none;">40%</TD><TD class="xl74" style="border-top: none; border-left: none;">60%</TD><TD class="xl73" style="border-top: none; border-left: none;">558,588</TD><TD class="xl74" style="border-top: none; border-left: none;">42%</TD><TD class="xl74" style="border-top: none; border-left: none;">58%</TD><TD class="xl73" style="border-top: none; border-left: none;">603,816</TD></TR><TR style="height: 15.0pt;"><TD class="xl76" height="20" style="height: 15.0pt; border-top: none;">44%</TD><TD class="xl76" style="border-top: none; border-left: none;">56%</TD><TD class="xl75" style="border-top: none; border-left: none;">145,166</TD><TD class="xl76" style="border-top: none; border-left: none;">45%</TD><TD class="xl76" style="border-top: none; border-left: none;">55%</TD><TD class="xl75" style="border-top: none; border-left: none;">165,081</TD></TR><TR style="height: 15.0pt;"><TD class="xl78" height="20" style="height: 15.0pt; border-top: none;">50%</TD><TD class="xl78" style="border-top: none; border-left: none;">50%</TD><TD class="xl77" style="border-top: none; border-left: none;">38,166</TD><TD class="xl78" style="border-top: none; border-left: none;">50%</TD><TD class="xl78" style="border-top: none; border-left: none;">50%</TD><TD class="xl77" style="border-top: none; border-left: none;">51,720</TD></TR><TR style="height: 15.0pt;"><TD class="xl74" height="20" style="height: 15.0pt; border-top: none;">53%</TD><TD class="xl74" style="border-top: none; border-left: none;">47%</TD><TD class="xl73" style="border-top: none; border-left: none;">11,986</TD><TD class="xl74" style="border-top: none; border-left: none;">53%</TD><TD class="xl74" style="border-top: none; border-left: none;">47%</TD><TD class="xl73" style="border-top: none; border-left: none;">14,053</TD></TR></TBODY></TABLE><P></P><P>Total comes using show partial sum, but it shows in % as Perc is in %, but I want it in numbers.</P><P></P><P>Plz solve this problem</P><P>Thanking You</P></BODY></HTML> Fri, 12 Dec 2014 10:55:31 GMT https://community.qlik.com/t5/QlikView/pivot/m-p/822958#M1039625 tyagishaila 2014-12-12T10:55:31Z Re: pivot https://community.qlik.com/t5/QlikView/pivot/m-p/822959#M1039626 <HTML><HEAD></HEAD><BODY><P>what is the problem here.</P></BODY></HTML> Fri, 12 Dec 2014 10:59:44 GMT https://community.qlik.com/t5/QlikView/pivot/m-p/822959#M1039626 SunilChauhan 2014-12-12T10:59:44Z Re: pivot https://community.qlik.com/t5/QlikView/pivot/m-p/822960#M1039627 <HTML><HEAD></HEAD><BODY><P>Sorry I think by mistake information is deleted.</P></BODY></HTML> Fri, 12 Dec 2014 11:06:58 GMT https://community.qlik.com/t5/QlikView/pivot/m-p/822960#M1039627 tyagishaila 2014-12-12T11:06:58Z Re: pivot https://community.qlik.com/t5/QlikView/pivot/m-p/822961#M1039628 <HTML><HEAD></HEAD><BODY><P>My required table form is</P><P>&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;&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;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 479px;"><TBODY><TR><TD colspan="1">Loyality</TD><TD colspan="1">NoLoyality</TD><TD colspan="1">Total</TD><TD colspan="1">Loyality</TD><TD colspan="1">NoLoyality</TD><TD colspan="1">Total</TD></TR><TR style="height: 15.0pt;"><TD class="xl79" height="20" style="height: 15.0pt; width: 60pt;" width="80">perc</TD><TD class="xl79" style="border-left: none; width: 68pt;" width="91">perc</TD><TD class="xl79" style="border-left: none; width: 58pt;" width="77">Sale</TD><TD class="xl79" style="border-left: none; width: 57pt;" width="76">Perc</TD><TD class="xl79" style="border-left: none; width: 59pt;" width="78">Perc</TD><TD class="xl79" style="border-left: none; width: 58pt;" width="77">Sale</TD></TR><TR style="height: 15.0pt;"><TD class="xl74" height="20" style="height: 15.0pt; border-top: none;">40%</TD><TD class="xl74" style="border-top: none; border-left: none;">60%</TD><TD class="xl73" style="border-top: none; border-left: none;">558,588</TD><TD class="xl74" style="border-top: none; border-left: none;">42%</TD><TD class="xl74" style="border-top: none; border-left: none;">58%</TD><TD class="xl73" style="border-top: none; border-left: none;">603,816</TD></TR><TR style="height: 15.0pt;"><TD class="xl76" height="20" style="height: 15.0pt; border-top: none;">44%</TD><TD class="xl76" style="border-top: none; border-left: none;">56%</TD><TD class="xl75" style="border-top: none; border-left: none;">145,166</TD><TD class="xl76" style="border-top: none; border-left: none;">45%</TD><TD class="xl76" style="border-top: none; border-left: none;">55%</TD><TD class="xl75" style="border-top: none; border-left: none;">165,081</TD></TR><TR style="height: 15.0pt;"><TD class="xl78" height="20" style="height: 15.0pt; border-top: none;">50%</TD><TD class="xl78" style="border-top: none; border-left: none;">50%</TD><TD class="xl77" style="border-top: none; border-left: none;">38,166</TD><TD class="xl78" style="border-top: none; border-left: none;">50%</TD><TD class="xl78" style="border-top: none; border-left: none;">50%</TD><TD class="xl77" style="border-top: none; border-left: none;">51,720</TD></TR><TR style="height: 15.0pt;"><TD class="xl74" height="20" style="height: 15.0pt; border-top: none;">53%</TD><TD class="xl74" style="border-top: none; border-left: none;">47%</TD><TD class="xl73" style="border-top: none; border-left: none;">11,986</TD><TD class="xl74" style="border-top: none; border-left: none;">53%</TD><TD class="xl74" style="border-top: none; border-left: none;">47%</TD><TD class="xl73" style="border-top: none; border-left: none;">14,053</TD></TR></TBODY></TABLE><P></P><P></P><P>If I am using partial sum then total comes in % but my need is in numbers</P></BODY></HTML> Fri, 12 Dec 2014 11:11:24 GMT https://community.qlik.com/t5/QlikView/pivot/m-p/822961#M1039628 tyagishaila 2014-12-12T11:11:24Z