topic Re: help with Pivot in QlikView https://community.qlik.com/t5/QlikView/help-with-Pivot/m-p/1176744#M892300 <HTML><HEAD></HEAD><BODY><P>See attached if it helps</P><P></P><P><IMG alt="recentgrp.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/134369_recentgrp.JPG" style="height: auto;" /></P></BODY></HTML> Thu, 11 Aug 2016 19:14:37 GMT vinieme12 2016-08-11T19:14:37Z help with Pivot https://community.qlik.com/t5/QlikView/help-with-Pivot/m-p/1176741#M892297 <HTML><HEAD></HEAD><BODY><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 576px;"><TBODY><TR><TD colspan="9" height="60" rowspan="3" style="border: 0px black;" width="576"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">My requirement is&nbsp; to count how many group he changed in last lets say 4 months. Sept being my most recent group. The user want to pivot&nbsp; report comparing&nbsp; last group( also called most recent group )with all previous groups and count him in that group </SPAN></TD></TR><TR></TR><TR></TR></TBODY></TABLE><P></P><P></P><P></P><P>&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" height="532" style="width: 473px; height: 437px;"><TBODY><TR><TD height="20" style="border: 0px black;" width="139"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">People ID</SPAN></TD><TD style="border: 0px black;" width="64"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">MONTH</SPAN></TD><TD style="border: 0px black;" width="64"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">GRP</SPAN></TD><TD></TD></TR><TR><TD align="right" height="20" style="border: 0px black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">1</SPAN></TD><TD style="border: 0px black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">jan</SPAN></TD><TD style="border: 0px black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">A</SPAN></TD><TD></TD></TR><TR><TD align="right" height="20" style="border: 0px black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">1</SPAN></TD><TD style="border: 0px black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">feb</SPAN></TD><TD style="border: 0px black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">A</SPAN></TD><TD></TD></TR><TR><TD align="right" height="20" style="border: 0px black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">1</SPAN></TD><TD style="border: 0px black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">mar</SPAN></TD><TD style="border: 0px black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">B</SPAN></TD><TD></TD></TR><TR><TD align="right" height="20" style="border: 0px black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">1</SPAN></TD><TD style="border: 0px black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">apr</SPAN></TD><TD style="border: 0px black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">B</SPAN></TD><TD></TD></TR><TR><TD align="right" height="20" style="border: 0px black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">1</SPAN></TD><TD style="border: 0px black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">may</SPAN></TD><TD style="border: 0px black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">C</SPAN></TD><TD></TD></TR><TR><TD align="right" height="20" style="border: 0px black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">1</SPAN></TD><TD style="border: 0px black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">jun</SPAN></TD><TD style="border: 0px black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">D</SPAN></TD><TD></TD></TR><TR><TD align="right" height="20" style="border: 0px black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">1</SPAN></TD><TD style="border: 0px black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">jul</SPAN></TD><TD style="border: 0px black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">D</SPAN></TD><TD></TD></TR><TR><TD align="right" height="20" style="border: 0px black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">1</SPAN></TD><TD style="border: 0px black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">aug</SPAN></TD><TD style="border: 0px black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">C</SPAN></TD><TD></TD></TR><TR><TD align="right" height="20" style="border: 0px black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">1</SPAN></TD><TD style="border: 0px black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">sep</SPAN></TD><TD style="border: 0px black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">A</SPAN></TD><TD></TD></TR><TR><TD colspan="5" style="border: 0px black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">&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;&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; Most Recent&nbsp; plan GRP</SPAN></TD></TR><TR><TD style="border: 0px black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">&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; </SPAN></TD><TD style="border: 0px black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">&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; </SPAN></TD><TD style="border: 0px black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">&nbsp;&nbsp; A</SPAN></TD><TD style="border: 0px black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">&nbsp;&nbsp;&nbsp;&nbsp; B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; C&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; D</SPAN></TD><TD></TD></TR><TR><TD height="180" rowspan="4" style="border: 0px black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">previous plan group</SPAN></TD><TD style="border: 0px black;">A</TD></TR><TR><TD height="20" style="border: 0px black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">B</SPAN></TD><TD align="right" style="border: 0px black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;"><BR /></SPAN></TD><TD>1</TD></TR><TR><TD height="20" style="border: 0px black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">C</SPAN></TD><TD align="right" style="border: 0px black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;"><BR /></SPAN></TD><TD>1</TD></TR><TR><TD height="20" style="border: 0px black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">D</SPAN></TD><TD align="right" style="border: 0px black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;"><BR /></SPAN></TD><TD>1</TD></TR></TBODY></TABLE><P>&nbsp; Please see actual requirement in xls file</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/help-with-Pivot/m-p/1176741#M892297 arusanah 2020-11-25T16:16:04Z Re: help with Pivot https://community.qlik.com/t5/QlikView/help-with-Pivot/m-p/1176742#M892298 <HTML><HEAD></HEAD><BODY><P>Sorry Not able to visualize your final output required!</P><P></P><P>Can you post a sample table in excel that shows how your final output should be</P></BODY></HTML> Thu, 11 Aug 2016 17:19:26 GMT https://community.qlik.com/t5/QlikView/help-with-Pivot/m-p/1176742#M892298 vinieme12 2016-08-11T17:19:26Z Re: help with Pivot https://community.qlik.com/t5/QlikView/help-with-Pivot/m-p/1176743#M892299 <HTML><HEAD></HEAD><BODY><P>pls check attached xls document </P></BODY></HTML> Thu, 11 Aug 2016 17:33:22 GMT https://community.qlik.com/t5/QlikView/help-with-Pivot/m-p/1176743#M892299 arusanah 2016-08-11T17:33:22Z Re: help with Pivot https://community.qlik.com/t5/QlikView/help-with-Pivot/m-p/1176744#M892300 <HTML><HEAD></HEAD><BODY><P>See attached if it helps</P><P></P><P><IMG alt="recentgrp.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/134369_recentgrp.JPG" style="height: auto;" /></P></BODY></HTML> Thu, 11 Aug 2016 19:14:37 GMT https://community.qlik.com/t5/QlikView/help-with-Pivot/m-p/1176744#M892300 vinieme12 2016-08-11T19:14:37Z