topic Vintage Analysis in QlikView https://community.qlik.com/t5/QlikView/Vintage-Analysis/m-p/1401540#M458963 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>Please find attached data </P><P>I have Table1 like this and need to arrange like Table 2.Can somebody let me know what is the workaround i.e using in set analysis to get output like Table 2 </P><P><STRONG style="text-decoration: underline;"> Table 1 :</STRONG></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 512px;"><TBODY><TR><TD height="20" width="64">Row Labels</TD><TD width="64">Sum of Aug 2016</TD><TD width="64">Sum of Sep 2016</TD><TD width="64">Sum of Oct 2016</TD><TD width="64">Sum of Nov 2016</TD><TD width="64">Sum of Dec 2016</TD><TD width="64">Sum of Jan 2017</TD><TD width="64">Sum of Feb 2017</TD></TR><TR><TD height="20">Jul 2016</TD><TD align="right">3</TD><TD align="right">9</TD><TD align="right">35</TD><TD align="right">1494</TD><TD align="right">2767</TD><TD align="right">2032</TD><TD align="right">1510</TD></TR><TR><TD height="20">Aug 2016</TD><TD></TD><TD align="right">2</TD><TD align="right">12</TD><TD align="right">1194</TD><TD align="right">2547</TD><TD align="right">2001</TD><TD align="right">1469</TD></TR><TR><TD height="20">Sep 2016</TD><TD></TD><TD></TD><TD align="right">9</TD><TD align="right">784</TD><TD align="right">1849</TD><TD align="right">1712</TD><TD align="right">1258</TD></TR><TR><TD height="20">Oct 2016</TD><TD></TD><TD></TD><TD></TD><TD align="right">392</TD><TD align="right">1949</TD><TD align="right">1990</TD><TD align="right">1460</TD></TR><TR><TD height="20">Nov 2016</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD align="right">173</TD><TD align="right">496</TD><TD align="right">266</TD></TR><TR><TD height="20">Dec 2016</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD align="right">2</TD><TD align="right">12</TD></TR><TR><TD height="20">Jan 2017</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD align="right">22</TD></TR><TR><TD height="20">Feb 2017</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR><TD height="20">Mar 2017</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR></TBODY></TABLE><P></P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" jive-data-cell="{&quot;color&quot;:&quot;#575757&quot;,&quot;textAlign&quot;:&quot;left&quot;,&quot;padding&quot;:&quot;NaN&quot;,&quot;backgroundColor&quot;:&quot;transparent&quot;,&quot;fontFamily&quot;:&quot;arial,helvetica,sans-serif&quot;,&quot;verticalAlign&quot;:&quot;baseline&quot;}" jive-data-header="{&quot;color&quot;:&quot;#FFFFFF&quot;,&quot;backgroundColor&quot;:&quot;#6690BC&quot;,&quot;textAlign&quot;:&quot;center&quot;,&quot;padding&quot;:&quot;2&quot;}" style="width: 1002px;"><TBODY><TR><TH style="color: #ffffff; background-color: #6690bc; text-align: center; padding: 2px;">Row Labels</TH><TD class="xl64" width="112">MOB1</TD><TD class="xl64" width="111">MOB2</TD><TD class="xl64" width="110">MOB3</TD><TD class="xl64" width="113">MOB4</TD><TD class="xl64" width="112">MOB5</TD><TD class="xl64" width="109">MOB6</TD><TD class="xl64" width="111">MOB7</TD><TD class="xl64" width="114">MOB8</TD></TR><TR><TD class="xl63" height="20">Jul 2016</TD><TD class="xl65"> 3 </TD><TD class="xl65"> 9 </TD><TD class="xl65"> 35 </TD><TD class="xl65"> 1,494 </TD><TD class="xl65"> 2,767 </TD><TD class="xl65"> 2,032 </TD><TD class="xl65"> 1,510 </TD><TD class="xl65"> 1,185 </TD></TR><TR><TD class="xl63" height="20">Aug 2016</TD><TD class="xl65"> 2 </TD><TD class="xl65"> 12 </TD><TD class="xl65"> 1,194 </TD><TD class="xl65"> 2,547 </TD><TD class="xl65"> 2,001 </TD><TD class="xl65"> 1,469 </TD><TD class="xl65"> 1,102 </TD><TD class="xl65"> 1,274 </TD></TR><TR><TD class="xl63" height="20">Sep 2016</TD><TD class="xl65"> 9 </TD><TD class="xl65"> 784 </TD><TD class="xl65"> 1,849 </TD><TD class="xl65"> 1,712 </TD><TD class="xl65"> 1,258 </TD><TD class="xl65"> 924 </TD><TD class="xl65"> 1,008 </TD><TD class="xl65"> 938 </TD></TR><TR><TD class="xl63" height="20">Oct 2016</TD><TD class="xl65"> 392 </TD><TD class="xl65"> 1,949 </TD><TD class="xl65"> 1,990 </TD><TD class="xl65"> 1,460 </TD><TD class="xl65"> 1,060 </TD><TD class="xl65"> 1,099 </TD><TD class="xl65"> 1,032 </TD><TD class="xl65"> 1,043 </TD></TR><TR><TD class="xl63" height="20">Nov 2016</TD><TD class="xl65"> 173 </TD><TD class="xl65"> 496 </TD><TD class="xl65"> 266 </TD><TD class="xl65"> 203 </TD><TD class="xl65"> 191 </TD><TD class="xl65"> 205 </TD><TD class="xl65"> 195 </TD><TD class="xl65"> 155 </TD></TR><TR><TD class="xl63" height="20">Dec 2016</TD><TD class="xl65"> 2 </TD><TD class="xl65"> 12 </TD><TD class="xl65"> 6 </TD><TD class="xl65"> 16 </TD><TD class="xl65"> 20 </TD><TD class="xl65"> 11 </TD><TD class="xl65"> 20 </TD><TD class="xl65"> 32 </TD></TR><TR><TD class="xl63" height="20">Jan 2017</TD><TD class="xl65"> 22 </TD><TD class="xl65"> 66 </TD><TD class="xl65"> 130 </TD><TD class="xl65"> 165 </TD><TD class="xl65"> 154 </TD><TD class="xl65"> 117 </TD><TD class="xl65"> 128 </TD><TD class="xl65"> -&nbsp;&nbsp; </TD></TR><TR><TD class="xl63" height="20">Feb 2017</TD><TD class="xl65"> 37 </TD><TD class="xl65"> 80 </TD><TD class="xl65"> 79 </TD><TD class="xl65"> 90 </TD><TD class="xl65"> 83 </TD><TD class="xl65"> 105 </TD><TD class="xl65"> -&nbsp;&nbsp; </TD><TD class="xl65"> -&nbsp;&nbsp; </TD></TR><TR><TD class="xl63" height="20">Mar 2017</TD><TD class="xl65"> 21 </TD><TD class="xl65"> 60 </TD><TD class="xl65"> 69 </TD><TD class="xl65"> 91 </TD><TD class="xl65"> 102 </TD><TD class="xl65"> -&nbsp;&nbsp; </TD><TD class="xl65"> -&nbsp;&nbsp; </TD><TD class="xl65"> -&nbsp;&nbsp; </TD></TR></TBODY></TABLE></BODY></HTML> Thu, 16 Nov 2017 10:15:02 GMT Anonymous 2017-11-16T10:15:02Z Vintage Analysis https://community.qlik.com/t5/QlikView/Vintage-Analysis/m-p/1401540#M458963 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>Please find attached data </P><P>I have Table1 like this and need to arrange like Table 2.Can somebody let me know what is the workaround i.e using in set analysis to get output like Table 2 </P><P><STRONG style="text-decoration: underline;"> Table 1 :</STRONG></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 512px;"><TBODY><TR><TD height="20" width="64">Row Labels</TD><TD width="64">Sum of Aug 2016</TD><TD width="64">Sum of Sep 2016</TD><TD width="64">Sum of Oct 2016</TD><TD width="64">Sum of Nov 2016</TD><TD width="64">Sum of Dec 2016</TD><TD width="64">Sum of Jan 2017</TD><TD width="64">Sum of Feb 2017</TD></TR><TR><TD height="20">Jul 2016</TD><TD align="right">3</TD><TD align="right">9</TD><TD align="right">35</TD><TD align="right">1494</TD><TD align="right">2767</TD><TD align="right">2032</TD><TD align="right">1510</TD></TR><TR><TD height="20">Aug 2016</TD><TD></TD><TD align="right">2</TD><TD align="right">12</TD><TD align="right">1194</TD><TD align="right">2547</TD><TD align="right">2001</TD><TD align="right">1469</TD></TR><TR><TD height="20">Sep 2016</TD><TD></TD><TD></TD><TD align="right">9</TD><TD align="right">784</TD><TD align="right">1849</TD><TD align="right">1712</TD><TD align="right">1258</TD></TR><TR><TD height="20">Oct 2016</TD><TD></TD><TD></TD><TD></TD><TD align="right">392</TD><TD align="right">1949</TD><TD align="right">1990</TD><TD align="right">1460</TD></TR><TR><TD height="20">Nov 2016</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD align="right">173</TD><TD align="right">496</TD><TD align="right">266</TD></TR><TR><TD height="20">Dec 2016</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD align="right">2</TD><TD align="right">12</TD></TR><TR><TD height="20">Jan 2017</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD align="right">22</TD></TR><TR><TD height="20">Feb 2017</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR><TD height="20">Mar 2017</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR></TBODY></TABLE><P></P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" jive-data-cell="{&quot;color&quot;:&quot;#575757&quot;,&quot;textAlign&quot;:&quot;left&quot;,&quot;padding&quot;:&quot;NaN&quot;,&quot;backgroundColor&quot;:&quot;transparent&quot;,&quot;fontFamily&quot;:&quot;arial,helvetica,sans-serif&quot;,&quot;verticalAlign&quot;:&quot;baseline&quot;}" jive-data-header="{&quot;color&quot;:&quot;#FFFFFF&quot;,&quot;backgroundColor&quot;:&quot;#6690BC&quot;,&quot;textAlign&quot;:&quot;center&quot;,&quot;padding&quot;:&quot;2&quot;}" style="width: 1002px;"><TBODY><TR><TH style="color: #ffffff; background-color: #6690bc; text-align: center; padding: 2px;">Row Labels</TH><TD class="xl64" width="112">MOB1</TD><TD class="xl64" width="111">MOB2</TD><TD class="xl64" width="110">MOB3</TD><TD class="xl64" width="113">MOB4</TD><TD class="xl64" width="112">MOB5</TD><TD class="xl64" width="109">MOB6</TD><TD class="xl64" width="111">MOB7</TD><TD class="xl64" width="114">MOB8</TD></TR><TR><TD class="xl63" height="20">Jul 2016</TD><TD class="xl65"> 3 </TD><TD class="xl65"> 9 </TD><TD class="xl65"> 35 </TD><TD class="xl65"> 1,494 </TD><TD class="xl65"> 2,767 </TD><TD class="xl65"> 2,032 </TD><TD class="xl65"> 1,510 </TD><TD class="xl65"> 1,185 </TD></TR><TR><TD class="xl63" height="20">Aug 2016</TD><TD class="xl65"> 2 </TD><TD class="xl65"> 12 </TD><TD class="xl65"> 1,194 </TD><TD class="xl65"> 2,547 </TD><TD class="xl65"> 2,001 </TD><TD class="xl65"> 1,469 </TD><TD class="xl65"> 1,102 </TD><TD class="xl65"> 1,274 </TD></TR><TR><TD class="xl63" height="20">Sep 2016</TD><TD class="xl65"> 9 </TD><TD class="xl65"> 784 </TD><TD class="xl65"> 1,849 </TD><TD class="xl65"> 1,712 </TD><TD class="xl65"> 1,258 </TD><TD class="xl65"> 924 </TD><TD class="xl65"> 1,008 </TD><TD class="xl65"> 938 </TD></TR><TR><TD class="xl63" height="20">Oct 2016</TD><TD class="xl65"> 392 </TD><TD class="xl65"> 1,949 </TD><TD class="xl65"> 1,990 </TD><TD class="xl65"> 1,460 </TD><TD class="xl65"> 1,060 </TD><TD class="xl65"> 1,099 </TD><TD class="xl65"> 1,032 </TD><TD class="xl65"> 1,043 </TD></TR><TR><TD class="xl63" height="20">Nov 2016</TD><TD class="xl65"> 173 </TD><TD class="xl65"> 496 </TD><TD class="xl65"> 266 </TD><TD class="xl65"> 203 </TD><TD class="xl65"> 191 </TD><TD class="xl65"> 205 </TD><TD class="xl65"> 195 </TD><TD class="xl65"> 155 </TD></TR><TR><TD class="xl63" height="20">Dec 2016</TD><TD class="xl65"> 2 </TD><TD class="xl65"> 12 </TD><TD class="xl65"> 6 </TD><TD class="xl65"> 16 </TD><TD class="xl65"> 20 </TD><TD class="xl65"> 11 </TD><TD class="xl65"> 20 </TD><TD class="xl65"> 32 </TD></TR><TR><TD class="xl63" height="20">Jan 2017</TD><TD class="xl65"> 22 </TD><TD class="xl65"> 66 </TD><TD class="xl65"> 130 </TD><TD class="xl65"> 165 </TD><TD class="xl65"> 154 </TD><TD class="xl65"> 117 </TD><TD class="xl65"> 128 </TD><TD class="xl65"> -&nbsp;&nbsp; </TD></TR><TR><TD class="xl63" height="20">Feb 2017</TD><TD class="xl65"> 37 </TD><TD class="xl65"> 80 </TD><TD class="xl65"> 79 </TD><TD class="xl65"> 90 </TD><TD class="xl65"> 83 </TD><TD class="xl65"> 105 </TD><TD class="xl65"> -&nbsp;&nbsp; </TD><TD class="xl65"> -&nbsp;&nbsp; </TD></TR><TR><TD class="xl63" height="20">Mar 2017</TD><TD class="xl65"> 21 </TD><TD class="xl65"> 60 </TD><TD class="xl65"> 69 </TD><TD class="xl65"> 91 </TD><TD class="xl65"> 102 </TD><TD class="xl65"> -&nbsp;&nbsp; </TD><TD class="xl65"> -&nbsp;&nbsp; </TD><TD class="xl65"> -&nbsp;&nbsp; </TD></TR></TBODY></TABLE></BODY></HTML> Thu, 16 Nov 2017 10:15:02 GMT https://community.qlik.com/t5/QlikView/Vintage-Analysis/m-p/1401540#M458963 Anonymous 2017-11-16T10:15:02Z