topic Re: PIVOT TABLE in QlikView https://community.qlik.com/t5/QlikView/PIVOT-TABLE/m-p/1097263#M364419 <HTML><HEAD></HEAD><BODY><P>Hi Kush</P><P></P><P>Hope my illustration will help you find an answer my issue. Will you please help me with a sloution</P></BODY></HTML> Mon, 07 Mar 2016 05:20:37 GMT upaliwije 2016-03-07T05:20:37Z PIVOT TABLE https://community.qlik.com/t5/QlikView/PIVOT-TABLE/m-p/1097255#M364411 <HTML><HEAD></HEAD><BODY><P>Hi Friends</P><P></P><P>I am doing an analysis of Insurance related data and sample of my data is given below</P><P></P><TABLE><TBODY><TR><TD>POLICY_NO</TD><TD>YEAR</TD><TD>PERIOD_FROM</TD><TD>PERIOD_TO</TD><TD>NEW_REN</TD><TD>PREMIUM</TD></TR><TR><TD>NI00111C000039</TD><TD>2012</TD><TD>10-Feb-2012</TD><TD>09-Feb-2013</TD><TD>REN</TD><TD>18,212</TD></TR><TR><TD>NI00111C000039</TD><TD>2013</TD><TD>10-Feb-2013</TD><TD>09-Feb-2014</TD><TD>REN</TD><TD>17,372</TD></TR><TR><TD>NI00111C000039</TD><TD>2014</TD><TD>10-Feb-2014</TD><TD>09-Feb-2015</TD><TD>REN</TD><TD>16,278</TD></TR><TR><TD>NI00131A000028</TD><TD>2013</TD><TD>13-May-2013</TD><TD>12-May-2014</TD><TD>NEW</TD><TD>59,793</TD></TR><TR><TD>NI00131A000028</TD><TD>2014</TD><TD>13-May-2014</TD><TD>12-May-2015</TD><TD>REN</TD><TD>29,782</TD></TR><TR><TD>NI00141A0000041</TD><TD>2014</TD><TD>06-Oct-2014</TD><TD>05-Oct-2015</TD><TD>NEW</TD><TD>28,311</TD></TR><TR><TD>NI00141A0000041</TD><TD>2015</TD><TD>06-Oct-2015</TD><TD>05-Oct-2016</TD><TD>REN</TD><TD>27,205</TD></TR><TR><TD>NI00121F000014</TD><TD>2012</TD><TD>06-Mar-2012</TD><TD>05-Mar-2013</TD><TD>NEW</TD><TD>13,969</TD></TR><TR><TD>NI00121F000014</TD><TD>2013</TD><TD>06-Mar-2013</TD><TD>05-Mar-2014</TD><TD>REN</TD><TD>12,728</TD></TR><TR><TD>NI00121F000014</TD><TD>2014</TD><TD>06-Mar-2014</TD><TD>05-Mar-2015</TD><TD>REN</TD><TD>11,885</TD></TR><TR><TD>NI00121F000014</TD><TD>2015</TD><TD>06-Mar-2015</TD><TD>05-Mar-2016</TD><TD>REN</TD><TD>11,619</TD></TR><TR><TD>NI00111D000019</TD><TD>2012</TD><TD>31-May-2012</TD><TD>30-May-2013</TD><TD>REN</TD><TD>72,310</TD></TR><TR><TD>NI00111D000019</TD><TD>2013</TD><TD>31-May-2013</TD><TD>30-May-2014</TD><TD>REN</TD><TD>69,927</TD></TR><TR><TD>NI00141C0000106</TD><TD>2014</TD><TD>13-Oct-2014</TD><TD>12-Oct-2015</TD><TD>NEW</TD><TD>35,030</TD></TR><TR><TD>NI00141C0000106</TD><TD>2015</TD><TD>13-Oct-2015</TD><TD>12-Oct-2016</TD><TD>REN</TD><TD>33,205</TD></TR><TR><TD>NI00121D000053</TD><TD>2012</TD><TD>23-May-2012</TD><TD>22-May-2013</TD><TD>NEW</TD><TD>39,059</TD></TR><TR><TD>NI00121D000053</TD><TD>2013</TD><TD>23-May-2013</TD><TD>22-May-2014</TD><TD>REN</TD><TD>35,262</TD></TR></TBODY></TABLE><P></P><P> I want to summaries these policies into a table shown below</P><P></P><TABLE><TBODY><TR><TD>YEAR</TD><TD></TD><TD>2012</TD><TD>2013</TD><TD>2014</TD><TD>2015</TD></TR><TR><TD>2012</TD><TD>NEW</TD><TD>2</TD><TD></TD><TD></TD><TD></TD></TR><TR><TD> </TD><TD>REN</TD><TD>2</TD><TD>4</TD><TD>2</TD><TD>1</TD></TR><TR><TD>2013</TD><TD>NEW</TD><TD></TD><TD>1</TD><TD></TD><TD> </TD></TR><TR><TD> </TD><TD>REN</TD><TD></TD><TD></TD><TD>1</TD><TD> </TD></TR><TR><TD>2014</TD><TD>NEW</TD><TD></TD><TD></TD><TD>2</TD><TD> </TD></TR><TR><TD> </TD><TD>REN</TD><TD></TD><TD></TD><TD></TD><TD>2</TD></TR><TR><TD>2015</TD><TD>NEW</TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR><TD></TD><TD>REN</TD><TD></TD><TD></TD><TD>&nbsp; </TD><TD> </TD></TR><TR><TD></TD><TD></TD><TD>4</TD><TD>5</TD><TD>5</TD><TD>3</TD></TR></TBODY></TABLE><P></P><P>If I am to explain my requirement</P><P>4 polices done in 2012 come under&nbsp; 2 New and 2 Renewal&nbsp; </P><P>Those 4&nbsp; are renewed in 2013 and 1 new policy done in 2013</P><P>Out of 4 policies done in 2012 only 2 are renewed in 2014 and 1&nbsp; in 2015</P><P> 2 new policies are done in 2014 and 1 policy is renewed from 2013 </P><P>..................</P><P></P><P>Hope you understand my requirement. </P><P>Kindly help me to tabulate above Requirement in QV document. Appreciate&nbsp; If sample QV doc&nbsp; is attched</P></BODY></HTML> Sun, 06 Mar 2016 02:49:18 GMT https://community.qlik.com/t5/QlikView/PIVOT-TABLE/m-p/1097255#M364411 upaliwije 2016-03-06T02:49:18Z Re: PIVOT TABLE https://community.qlik.com/t5/QlikView/PIVOT-TABLE/m-p/1097256#M364412 <HTML><HEAD></HEAD><BODY><P>Please see attached.</P></BODY></HTML> Sun, 06 Mar 2016 04:40:38 GMT https://community.qlik.com/t5/QlikView/PIVOT-TABLE/m-p/1097256#M364412 shamitshah 2016-03-06T04:40:38Z Re: PIVOT TABLE https://community.qlik.com/t5/QlikView/PIVOT-TABLE/m-p/1097257#M364413 <HTML><HEAD></HEAD><BODY><P><EM>Data:</EM></P><P><EM>LOAD * Inline [</EM></P><P><EM>POLICY_NO,&nbsp;&nbsp;&nbsp; YEAR,&nbsp;&nbsp;&nbsp; PERIOD_FROM,&nbsp;&nbsp;&nbsp; PERIOD_TO,&nbsp;&nbsp;&nbsp; NEW_REN,&nbsp;&nbsp;&nbsp; PREMIUM</EM></P><P><EM>NI00111C000039,&nbsp;&nbsp;&nbsp; 2012,&nbsp;&nbsp;&nbsp; 10-Feb-2012,&nbsp;&nbsp;&nbsp; 09-Feb-2013,&nbsp;&nbsp;&nbsp; REN,&nbsp;&nbsp;&nbsp; 18,212</EM></P><P><EM>NI00111C000039,&nbsp;&nbsp;&nbsp; 2013,&nbsp;&nbsp;&nbsp; 10-Feb-2013,&nbsp;&nbsp;&nbsp; 09-Feb-2014,&nbsp;&nbsp;&nbsp; REN,&nbsp;&nbsp;&nbsp; 17,372</EM></P><P><EM>NI00111C000039,&nbsp;&nbsp;&nbsp; 2014,&nbsp;&nbsp;&nbsp; 10-Feb-2014,&nbsp;&nbsp;&nbsp; 09-Feb-2015,&nbsp;&nbsp;&nbsp; REN,&nbsp;&nbsp;&nbsp; 16,278</EM></P><P><EM>NI00131A000028,&nbsp;&nbsp;&nbsp; 2013,&nbsp;&nbsp;&nbsp; 13-May-2013,&nbsp;&nbsp;&nbsp; 12-May-2014,&nbsp;&nbsp;&nbsp; NEW,&nbsp;&nbsp;&nbsp; 59,793</EM></P><P><EM>NI00131A000028,&nbsp;&nbsp;&nbsp; 2014,&nbsp;&nbsp;&nbsp; 13-May-2014,&nbsp;&nbsp;&nbsp; 12-May-2015,&nbsp;&nbsp;&nbsp; REN,&nbsp;&nbsp;&nbsp; 29,782</EM></P><P><EM>NI00141A0000041,&nbsp;&nbsp;&nbsp; 2014,&nbsp;&nbsp;&nbsp; 06-Oct-2014,&nbsp;&nbsp;&nbsp; 05-Oct-2015,&nbsp;&nbsp;&nbsp; NEW,&nbsp;&nbsp;&nbsp; 28,311</EM></P><P><EM>NI00141A0000041,&nbsp;&nbsp;&nbsp; 2015,&nbsp;&nbsp;&nbsp; 06-Oct-2015,&nbsp;&nbsp;&nbsp; 05-Oct-2016,&nbsp;&nbsp;&nbsp; REN,&nbsp;&nbsp;&nbsp; 27,205</EM></P><P><EM>NI00121F000014,&nbsp;&nbsp;&nbsp; 2012,&nbsp;&nbsp;&nbsp; 06-Mar-2012,&nbsp;&nbsp;&nbsp; 05-Mar-2013,&nbsp;&nbsp;&nbsp; NEW,&nbsp;&nbsp;&nbsp; 13,969</EM></P><P><EM>NI00121F000014,&nbsp;&nbsp;&nbsp; 2013,&nbsp;&nbsp;&nbsp; 06-Mar-2013,&nbsp;&nbsp;&nbsp; 05-Mar-2014,&nbsp;&nbsp;&nbsp; REN,&nbsp;&nbsp;&nbsp; 12,728</EM></P><P><EM>NI00121F000014,&nbsp;&nbsp;&nbsp; 2014,&nbsp;&nbsp;&nbsp; 06-Mar-2014,&nbsp;&nbsp;&nbsp; 05-Mar-2015,&nbsp;&nbsp;&nbsp; REN,&nbsp;&nbsp;&nbsp; 11,885</EM></P><P><EM>NI00121F000014,&nbsp;&nbsp;&nbsp; 2015,&nbsp;&nbsp;&nbsp; 06-Mar-2015,&nbsp;&nbsp;&nbsp; 05-Mar-2016,&nbsp;&nbsp;&nbsp; REN,&nbsp;&nbsp;&nbsp; 11,619</EM></P><P><EM>NI00111D000019,&nbsp;&nbsp;&nbsp; 2012,&nbsp;&nbsp;&nbsp; 31-May-2012,&nbsp;&nbsp;&nbsp; 30-May-2013,&nbsp;&nbsp;&nbsp; REN,&nbsp;&nbsp;&nbsp; 72,310</EM></P><P><EM>NI00111D000019,&nbsp;&nbsp;&nbsp; 2013,&nbsp;&nbsp;&nbsp; 31-May-2013,&nbsp;&nbsp;&nbsp; 30-May-2014,&nbsp;&nbsp;&nbsp; REN,&nbsp;&nbsp;&nbsp; 69,927</EM></P><P><EM>NI00141C0000106,&nbsp;&nbsp;&nbsp; 2014,&nbsp;&nbsp;&nbsp; 13-Oct-2014,&nbsp;&nbsp;&nbsp; 12-Oct-2015,&nbsp;&nbsp;&nbsp; NEW&nbsp;&nbsp;&nbsp; ,35,030</EM></P><P><EM>NI00141C0000106,&nbsp;&nbsp;&nbsp; 2015,&nbsp;&nbsp;&nbsp; 13-Oct-2015,&nbsp;&nbsp;&nbsp; 12-Oct-2016,&nbsp;&nbsp;&nbsp; REN,&nbsp;&nbsp;&nbsp; 33,205</EM></P><P><EM>NI00121D000053,&nbsp;&nbsp;&nbsp; 2012,&nbsp;&nbsp;&nbsp; 23-May-2012,&nbsp;&nbsp;&nbsp; 22-May-2013,&nbsp;&nbsp;&nbsp; NEW,&nbsp;&nbsp;&nbsp; 39,059</EM></P><P><EM>NI00121D000053,&nbsp;&nbsp;&nbsp; 2013,&nbsp;&nbsp;&nbsp; 23-May-2013,&nbsp;&nbsp;&nbsp; 22-May-2014,&nbsp;&nbsp;&nbsp; REN,&nbsp;&nbsp;&nbsp; 35,262 ];</EM></P><P></P><P><EM>New:</EM></P><P><EM>NoConcatenate</EM></P><P><EM>LOAD *,</EM></P><P><EM>if((RowNo()=1 or POLICY_NO&lt;&gt;Previous(POLICY_NO)) ,YEAR, </EM></P><P><EM>if(POLICY_NO=Previous(POLICY_NO) , Peek('YEAR1'))) as YEAR1</EM></P><P><EM>Resident Data</EM></P><P><EM>Order by POLICY_NO,YEAR asc;</EM></P><P></P><P><EM>DROP Table Data;</EM></P><P><EM><BR /></EM></P><P><EM><BR /></EM></P><P><EM>Create Pivot Table </EM></P><P><EM><STRONG>Dimensions:</STRONG></EM></P><P><EM>YEAR1,</EM></P><P><EM><EM> NEW_REN,</EM></EM></P><P><EM><EM>YEAR</EM></EM></P><P><EM><EM><BR /></EM></EM></P><P><EM><EM><STRONG>Expression:</STRONG></EM></EM></P><P><EM><EM>Count(<EM>POLICY_NO</EM>)<BR /></EM></EM></P><P><EM><BR /></EM></P><P><EM><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/117099_pastedImage_3.png" style="max-width: 1200px; max-height: 900px;" /></EM></P></BODY></HTML> Sun, 06 Mar 2016 07:56:25 GMT https://community.qlik.com/t5/QlikView/PIVOT-TABLE/m-p/1097257#M364413 Kushal_Chawda 2016-03-06T07:56:25Z Re: PIVOT TABLE https://community.qlik.com/t5/QlikView/PIVOT-TABLE/m-p/1097258#M364414 <HTML><HEAD></HEAD><BODY><P>Thanks Kush</P><P></P><P>One more help from You. same If I want to tabulate policies relating to a particular but were not renewed in subsequent years how can I script it please</P></BODY></HTML> Sun, 06 Mar 2016 09:24:46 GMT https://community.qlik.com/t5/QlikView/PIVOT-TABLE/m-p/1097258#M364414 upaliwije 2016-03-06T09:24:46Z Re: PIVOT TABLE https://community.qlik.com/t5/QlikView/PIVOT-TABLE/m-p/1097259#M364415 <HTML><HEAD></HEAD><BODY><P>If there is One New policy created in 2013 and which is not renewed in 2014, you need to list our this policy. this is what you mean?</P></BODY></HTML> Sun, 06 Mar 2016 09:29:28 GMT https://community.qlik.com/t5/QlikView/PIVOT-TABLE/m-p/1097259#M364415 Kushal_Chawda 2016-03-06T09:29:28Z Re: PIVOT TABLE https://community.qlik.com/t5/QlikView/PIVOT-TABLE/m-p/1097260#M364416 <HTML><HEAD></HEAD><BODY><P>I want to show number of policies that were not renewed in the same table as follows</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 360px;"><TBODY><TR><TD class="xl22" height="17" width="55">YEAR</TD><TD class="xl22" style="border-left: none;" width="63">NEW_REN</TD><TD class="xl23" width="35">YEAR</TD><TD class="xl24" style="border-left: none;" width="29">2012</TD><TD class="xl24" style="border-left: none;" width="29">2013</TD><TD class="xl24" style="border-left: none;" width="29"> </TD><TD class="xl24" style="border-left: none;" width="29">2014</TD><TD class="xl24" style="border-left: none;" width="29"> </TD><TD class="xl24" style="border-left: none;" width="29">2015</TD></TR><TR><TD class="xl33" height="17"> </TD><TD class="xl34" style="border-left: none;"> </TD><TD class="xl35"> </TD><TD class="xl24" style="border-top: none; border-left: none;">R</TD><TD class="xl24" style="border-top: none; border-left: none;">R</TD><TD class="xl24" style="border-top: none; border-left: none;">NR</TD><TD class="xl24" style="border-top: none; border-left: none;">R</TD><TD class="xl24" style="border-top: none; border-left: none;">NR</TD><TD class="xl24" style="border-top: none; border-left: none;">R</TD><TD class="xl24" style="border-left: none;">NR</TD></TR><TR><TD class="xl24" height="17" style="border-top: none;">2012</TD><TD class="xl25" style="border-top: none; border-left: none;">NEW</TD><TD class="xl26"> </TD><TD align="right" class="xl27" style="border-top: none; border-left: none;">2</TD><TD class="xl28" style="border-top: none; border-left: none;"> </TD><TD class="xl28" style="border-top: none; border-left: none;"> </TD><TD class="xl28" style="border-top: none; border-left: none;"> </TD><TD class="xl28" style="border-top: none; border-left: none;"> </TD><TD class="xl28" style="border-top: none; border-left: none;"> </TD></TR><TR><TD class="xl24" height="17" style="border-top: none;">2012</TD><TD class="xl25" style="border-top: none; border-left: none;">REN</TD><TD class="xl26" style="border-top: none;"> </TD><TD align="right" class="xl27" style="border-top: none; border-left: none;">2</TD><TD align="right" class="xl27" style="border-top: none; border-left: none;">4</TD><TD class="xl27" style="border-top: none; border-left: none;"> </TD><TD align="right" class="xl27" style="border-top: none; border-left: none;">2</TD><TD class="xl27" style="border-top: none; border-left: none;"> </TD><TD align="right" class="xl27" style="border-top: none; border-left: none;">1</TD></TR><TR><TD class="xl24" height="17" style="border-top: none;">2013</TD><TD class="xl25" style="border-top: none; border-left: none;">NEW</TD><TD class="xl26" style="border-top: none;"> </TD><TD class="xl28" style="border-top: none; border-left: none;"> </TD><TD align="right" class="xl27" style="border-top: none; border-left: none;">1</TD><TD class="xl27" style="border-top: none; border-left: none;"> </TD><TD class="xl28" style="border-top: none; border-left: none;"> </TD><TD class="xl28" style="border-top: none; border-left: none;"> </TD><TD class="xl28" style="border-top: none; border-left: none;"> </TD></TR><TR><TD class="xl24" height="17" style="border-top: none;">2013</TD><TD class="xl25" style="border-top: none; border-left: none;">REN</TD><TD class="xl26" style="border-top: none;"> </TD><TD class="xl28" style="border-top: none; border-left: none;"> </TD><TD class="xl28" style="border-top: none; border-left: none;"> </TD><TD class="xl28" style="border-top: none; border-left: none;"> </TD><TD align="right" class="xl27" style="border-top: none; border-left: none;">1</TD><TD class="xl27" style="border-top: none; border-left: none;"> </TD><TD class="xl28" style="border-top: none; border-left: none;"> </TD></TR><TR><TD class="xl24" height="17" style="border-top: none;">2014</TD><TD class="xl25" style="border-top: none; border-left: none;">NEW</TD><TD class="xl26" style="border-top: none;"> </TD><TD class="xl28" style="border-top: none; border-left: none;"> </TD><TD class="xl28" style="border-top: none; border-left: none;"> </TD><TD class="xl28" style="border-top: none; border-left: none;"> </TD><TD align="right" class="xl27" style="border-top: none; border-left: none;">2</TD><TD class="xl27" style="border-top: none; border-left: none;"> </TD><TD class="xl28" style="border-top: none; border-left: none;"> </TD></TR><TR><TD class="xl24" height="17" style="border-top: none;">2014</TD><TD class="xl25" style="border-top: none; border-left: none;">REN</TD><TD class="xl26" style="border-top: none;"> </TD><TD class="xl28" style="border-top: none; border-left: none;"> </TD><TD class="xl28" style="border-top: none; border-left: none;"> </TD><TD class="xl28" style="border-top: none; border-left: none;"> </TD><TD class="xl28" style="border-top: none; border-left: none;"> </TD><TD class="xl28" style="border-top: none; border-left: none;"> </TD><TD align="right" class="xl27" style="border-top: none; border-left: none;">2</TD></TR><TR><TD class="xl29" height="17" style="border-top: none;">Total</TD><TD class="xl30" style="border-top: none;"> </TD><TD class="xl31" style="border-top: none;"> </TD><TD align="right" class="xl32" style="border-top: none; border-left: none;">4</TD><TD align="right" class="xl32" style="border-top: none; border-left: none;">5</TD><TD class="xl32" style="border-top: none; border-left: none;"> </TD><TD align="right" class="xl32" style="border-top: none; border-left: none;">5</TD><TD class="xl32" style="border-top: none; border-left: none;"> </TD><TD align="right" class="xl32" style="border-top: none; border-left: none;">3</TD></TR></TBODY></TABLE></BODY></HTML> Sun, 06 Mar 2016 09:36:50 GMT https://community.qlik.com/t5/QlikView/PIVOT-TABLE/m-p/1097260#M364416 upaliwije 2016-03-06T09:36:50Z Re: PIVOT TABLE https://community.qlik.com/t5/QlikView/PIVOT-TABLE/m-p/1097261#M364417 <HTML><HEAD></HEAD><BODY><P>Output is not clear to me. Can you send the output in excel?</P></BODY></HTML> Sun, 06 Mar 2016 10:26:02 GMT https://community.qlik.com/t5/QlikView/PIVOT-TABLE/m-p/1097261#M364417 Kushal_Chawda 2016-03-06T10:26:02Z Re: PIVOT TABLE https://community.qlik.com/t5/QlikView/PIVOT-TABLE/m-p/1097262#M364418 <HTML><HEAD></HEAD><BODY><P>It is like this</P><P>There were 4 policies in 2012 (new 2+ ren2)</P><P>in 2013 all 4 policies were renewed therefore not renewed policies is 0</P><P>In 2014 out 4 policies in 2012 only 2 were renewed balance 2 fall into not renewed catagory</P><P>In 2015 1 is renewed and 3 not renewed </P><P>Hope u understand my need</P><P></P><P>below is the sample</P><P>&nbsp;&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" width="592"><TBODY><TR><TD class="xl64" height="17" width="64">YEAR</TD><TD class="xl64" style="border-left: none;" width="64">NEW_REN</TD><TD class="xl63" style="border-left: none;" width="64">2012</TD><TD class="xl63" style="border-left: none;" width="75">2013</TD><TD class="xl63" style="border-left: none;" width="69"> </TD><TD class="xl63" style="border-left: none;" width="64">2014</TD><TD class="xl63" style="border-left: none;" width="64"> </TD><TD class="xl63" style="border-left: none;" width="64">2015</TD></TR><TR><TD class="xl71">Renewed</TD><TD class="xl71">Renewed</TD><TD class="xl71">Not Renewed</TD><TD class="xl71">Renewed</TD><TD class="xl71">Not Renewed</TD><TD class="xl71">Renewed</TD><TD class="xl71">Not Renewed</TD></TR><TR><TD class="xl63" height="17">2012</TD><TD class="xl65" style="border-left: none;">NEW</TD><TD align="right" class="xl66">2</TD><TD class="xl67" style="border-left: none;"> </TD><TD class="xl67" style="border-left: none;"> </TD><TD class="xl67" style="border-left: none;"> </TD><TD class="xl67" style="border-left: none;"> </TD><TD class="xl67" style="border-left: none;"> </TD></TR><TR><TD class="xl63" height="17" style="border-top: none;">2012</TD><TD class="xl65" style="border-top: none; border-left: none;">REN</TD><TD align="right" class="xl66" style="border-top: none;">2</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">4</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">2</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">2</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">1</TD><TD align="right" class="xl72" style="border-left: none;">3</TD></TR><TR><TD class="xl63" height="17" style="border-top: none;">2013</TD><TD class="xl65" style="border-top: none; border-left: none;">NEW</TD><TD class="xl67" style="border-top: none;"> </TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">1</TD><TD class="xl66" style="border-top: none; border-left: none;"> </TD><TD class="xl67" style="border-top: none; border-left: none;"> </TD><TD class="xl67" style="border-top: none; border-left: none;"> </TD><TD class="xl67" style="border-top: none; border-left: none;"> </TD></TR><TR><TD class="xl63" height="17" style="border-top: none;">2013</TD><TD class="xl65" style="border-top: none; border-left: none;">REN</TD><TD class="xl67" style="border-top: none;"> </TD><TD class="xl67" style="border-top: none; border-left: none;"> </TD><TD class="xl67" style="border-top: none; border-left: none;"> </TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">1</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">0</TD><TD class="xl67" style="border-top: none; border-left: none;"> </TD><TD align="right">1</TD></TR><TR><TD class="xl63" height="17" style="border-top: none;">2014</TD><TD class="xl65" style="border-top: none; border-left: none;">NEW</TD><TD class="xl67" style="border-top: none;"> </TD><TD class="xl67" style="border-top: none; border-left: none;"> </TD><TD class="xl67" style="border-top: none; border-left: none;"> </TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">2</TD><TD class="xl66" style="border-top: none; border-left: none;"> </TD><TD class="xl67" style="border-top: none; border-left: none;"> </TD></TR><TR><TD class="xl63" height="17" style="border-top: none;">2014</TD><TD class="xl65" style="border-top: none; border-left: none;">REN</TD><TD class="xl67" style="border-top: none;"> </TD><TD class="xl67" style="border-top: none; border-left: none;"> </TD><TD class="xl67" style="border-top: none; border-left: none;"> </TD><TD class="xl67" style="border-top: none; border-left: none;"> </TD><TD class="xl67" style="border-top: none; border-left: none;"> </TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">2</TD></TR><TR><TD class="xl68" height="17" style="border-top: none;">Total</TD><TD class="xl69" style="border-top: none;"> </TD><TD align="right" class="xl70" style="border-top: none;">4</TD><TD align="right" class="xl70" style="border-top: none; border-left: none;">5</TD><TD class="xl70" style="border-top: none; border-left: none;"> </TD><TD align="right" class="xl70" style="border-top: none; border-left: none;">5</TD><TD class="xl70" style="border-top: none; border-left: none;"> </TD><TD align="right" class="xl70" style="border-top: none; border-left: none;">3</TD></TR></TBODY></TABLE><P></P><P>Pls help</P></BODY></HTML> Sun, 06 Mar 2016 10:54:55 GMT https://community.qlik.com/t5/QlikView/PIVOT-TABLE/m-p/1097262#M364418 upaliwije 2016-03-06T10:54:55Z Re: PIVOT TABLE https://community.qlik.com/t5/QlikView/PIVOT-TABLE/m-p/1097263#M364419 <HTML><HEAD></HEAD><BODY><P>Hi Kush</P><P></P><P>Hope my illustration will help you find an answer my issue. Will you please help me with a sloution</P></BODY></HTML> Mon, 07 Mar 2016 05:20:37 GMT https://community.qlik.com/t5/QlikView/PIVOT-TABLE/m-p/1097263#M364419 upaliwije 2016-03-07T05:20:37Z