topic Re: Pivot calculation in QlikView https://community.qlik.com/t5/QlikView/Pivot-calculation/m-p/736601#M539811 <HTML><HEAD></HEAD><BODY><P>wow! big thanks!</P></BODY></HTML> Mon, 25 Aug 2014 19:15:14 GMT omnomnom 2014-08-25T19:15:14Z Pivot calculation https://community.qlik.com/t5/QlikView/Pivot-calculation/m-p/736593#M539803 <HTML><HEAD></HEAD><BODY><P>Hi i have Excel table like this</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 497px;"><TBODY><TR><TD class="xl178" height="38" width="170"> </TD><TD class="xl177" style="border-left: none;" width="117"> </TD><TD class="xl179" style="border-left: none;" width="105">Suppl</TD><TD class="xl179" style="border-left: none;" width="105">SubCategory</TD></TR><TR><TD class="xl189" height="95" rowspan="2" style="border-bottom: .5pt solid black; border-top: none;" width="170">Category1</TD><TD class="xl181" style="border-top: none; border-left: none;">2012</TD><TD class="xl183" style="border-top: none; border-left: none;">10 627&nbsp; </TD><TD class="xl184" style="border-top: none; border-left: none;" width="105">144 423&nbsp; </TD></TR><TR><TD class="xl181" height="46" style="border-top: none; border-left: none;">2013</TD><TD class="xl185" style="border-top: none; border-left: none;">11 284&nbsp; </TD><TD class="xl186" style="border-top: none; border-left: none;" width="105">130 380&nbsp; </TD></TR><TR><TD class="xl182" height="38" style="border-top: none;"> </TD><TD class="xl181" style="border-top: none; border-left: none;"> </TD><TD class="xl175" style="border-top: none; border-left: none;">6%</TD><TD class="xl175" style="border-top: none; border-left: none;">-10%</TD></TR><TR><TD class="xl189" height="76" rowspan="2" style="border-bottom: .5pt solid black; border-top: none;" width="170">Category2</TD><TD class="xl181" style="border-top: none; border-left: none;">2012</TD><TD class="xl183" style="border-top: none; border-left: none;">10 627&nbsp; </TD><TD class="xl187" style="border-top: none; border-left: none;" width="105">565 008&nbsp; </TD></TR><TR><TD class="xl181" height="38" style="border-top: none; border-left: none;">2013</TD><TD class="xl185" style="border-top: none; border-left: none;">11 284&nbsp; </TD><TD class="xl188" style="border-top: none; border-left: none;" width="105">549 901&nbsp; </TD></TR><TR><TD class="xl182" height="38" style="border-top: none;"> </TD><TD class="xl181" style="border-top: none; border-left: none;"> </TD><TD class="xl175" style="border-top: none; border-left: none;">6%</TD><TD class="xl175" style="border-top: none; border-left: none;">-3%</TD></TR></TBODY></TABLE><P></P><P></P><P>How can i make it in qlikview?</P></BODY></HTML> Mon, 25 Aug 2014 14:05:11 GMT https://community.qlik.com/t5/QlikView/Pivot-calculation/m-p/736593#M539803 omnomnom 2014-08-25T14:05:11Z Re: Pivot calculation https://community.qlik.com/t5/QlikView/Pivot-calculation/m-p/736594#M539804 <HTML><HEAD></HEAD><BODY><P><A href="https://www.dropbox.com/s/xxib927y01jsk9w/xls.xls?dl=0" title="https://www.dropbox.com/s/xxib927y01jsk9w/xls.xls?dl=0">Dropbox - xls.xls</A></P><P></P><P>xls for better understanding</P></BODY></HTML> Mon, 25 Aug 2014 14:10:09 GMT https://community.qlik.com/t5/QlikView/Pivot-calculation/m-p/736594#M539804 omnomnom 2014-08-25T14:10:09Z Re: Pivot calculation https://community.qlik.com/t5/QlikView/Pivot-calculation/m-p/736595#M539805 <HTML><HEAD></HEAD><BODY><P>you can load the data without the % in QlikView and create the % difference as a column instead of a row.</P></BODY></HTML> Mon, 25 Aug 2014 14:13:12 GMT https://community.qlik.com/t5/QlikView/Pivot-calculation/m-p/736595#M539805 giakoum 2014-08-25T14:13:12Z Re: Pivot calculation https://community.qlik.com/t5/QlikView/Pivot-calculation/m-p/736596#M539806 <HTML><HEAD></HEAD><BODY><P>Hi, im already have pivot table </P><P></P><P>but im dont know how to add 2013/2014 diffirence to red line place</P><P><IMG alt="3mki3zr.png" class="jive-image" src="http://i.imgur.com/3mki3zr.png" /></P></BODY></HTML> Mon, 25 Aug 2014 14:17:11 GMT https://community.qlik.com/t5/QlikView/Pivot-calculation/m-p/736596#M539806 omnomnom 2014-08-25T14:17:11Z Re: Pivot calculation https://community.qlik.com/t5/QlikView/Pivot-calculation/m-p/736597#M539807 <HTML><HEAD></HEAD><BODY><P>this is result what i want to get/</P><P><IMG alt="R1EOkSJ.png" class="jive-image" src="http://i.imgur.com/R1EOkSJ.png" style="width: 620px; height: 281px;" /></P></BODY></HTML> Mon, 25 Aug 2014 14:22:02 GMT https://community.qlik.com/t5/QlikView/Pivot-calculation/m-p/736597#M539807 omnomnom 2014-08-25T14:22:02Z Re: Pivot calculation https://community.qlik.com/t5/QlikView/Pivot-calculation/m-p/736598#M539808 <HTML><HEAD></HEAD><BODY><P>the only way to achieve that is to create the rows in your data model while reloading. Otherwise I don't think it is possible.</P></BODY></HTML> Mon, 25 Aug 2014 14:33:29 GMT https://community.qlik.com/t5/QlikView/Pivot-calculation/m-p/736598#M539808 giakoum 2014-08-25T14:33:29Z Re: Pivot calculation https://community.qlik.com/t5/QlikView/Pivot-calculation/m-p/736599#M539809 <HTML><HEAD></HEAD><BODY><P>Check out the Dimensionality() function in the help page of QlikViw. It will help you.</P></BODY></HTML> Mon, 25 Aug 2014 14:46:21 GMT https://community.qlik.com/t5/QlikView/Pivot-calculation/m-p/736599#M539809 2014-08-25T14:46:21Z Re: Re: Pivot calculation https://community.qlik.com/t5/QlikView/Pivot-calculation/m-p/736600#M539810 <HTML><HEAD></HEAD><BODY><P><STRONG>Siarhei</STRONG></P><P></P><P>Have a look at the attached.</P><P></P><P></P><P>Best Regards,&nbsp;&nbsp;&nbsp; <STRONG>Bill</STRONG></P></BODY></HTML> Mon, 25 Aug 2014 18:15:59 GMT https://community.qlik.com/t5/QlikView/Pivot-calculation/m-p/736600#M539810 Anonymous 2014-08-25T18:15:59Z Re: Pivot calculation https://community.qlik.com/t5/QlikView/Pivot-calculation/m-p/736601#M539811 <HTML><HEAD></HEAD><BODY><P>wow! big thanks!</P></BODY></HTML> Mon, 25 Aug 2014 19:15:14 GMT https://community.qlik.com/t5/QlikView/Pivot-calculation/m-p/736601#M539811 omnomnom 2014-08-25T19:15:14Z