topic Re: Re: Repeating the values in a straight table/Pivot table in QlikView https://community.qlik.com/t5/QlikView/Repeating-the-values-in-a-straight-table-Pivot-table/m-p/482034#M687288 <HTML><HEAD></HEAD><BODY><P><STRONG>Manish</STRONG></P><P></P><P>Is the attached qvw the sort of thing you were after ?</P><P></P><P></P><P>Best Regards,&nbsp;&nbsp;&nbsp;&nbsp; <STRONG>Bill</STRONG></P></BODY></HTML> Sat, 23 Nov 2013 14:58:02 GMT Anonymous 2013-11-23T14:58:02Z Repeating the values in a straight table/Pivot table https://community.qlik.com/t5/QlikView/Repeating-the-values-in-a-straight-table-Pivot-table/m-p/482031#M687285 <HTML><HEAD></HEAD><BODY><P>Hi guys</P><P></P><P>I have a straight table as :</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="492"><TBODY><TR><TD class="xl65" height="20" width="130">Product_Code</TD><TD class="xl65" style="border-left: none;" width="125">CalendarMonth</TD><TD class="xl66" style="border-left: none;" width="110">StandardCost</TD><TD class="xl66" style="border-left: none;" width="127">Q</TD></TR><TR><TD class="xl68" height="240" rowspan="12" style="border-bottom: .5pt solid silver; border-top: none;" width="130">5002041</TD><TD class="xl67" style="border-top: none; border-left: none;" width="125">Jan</TD><TD class="xl67" style="border-top: none; border-left: none;" width="110">194567.77</TD><TD class="xl67" style="border-top: none; border-left: none;" width="127">93</TD></TR><TR><TD class="xl67" height="20" style="border-top: none; border-left: none;" width="125">Feb</TD><TD class="xl67" style="border-top: none; border-left: none;" width="110">0</TD><TD class="xl67" style="border-top: none; border-left: none;" width="127">108</TD></TR><TR><TD class="xl67" height="20" style="border-top: none; border-left: none;" width="125">Mar</TD><TD class="xl67" style="border-top: none; border-left: none;" width="110">0</TD><TD class="xl67" style="border-top: none; border-left: none;" width="127">114</TD></TR><TR><TD class="xl67" height="20" style="border-top: none; border-left: none;" width="125">Apr</TD><TD class="xl67" style="border-top: none; border-left: none;" width="110">0</TD><TD class="xl67" style="border-top: none; border-left: none;" width="127">92</TD></TR><TR><TD class="xl67" height="20" style="border-top: none; border-left: none;" width="125">May</TD><TD class="xl67" style="border-top: none; border-left: none;" width="110">0</TD><TD class="xl67" style="border-top: none; border-left: none;" width="127">52</TD></TR><TR><TD class="xl67" height="20" style="border-top: none; border-left: none;" width="125">Jun</TD><TD class="xl67" style="border-top: none; border-left: none;" width="110">0</TD><TD class="xl67" style="border-top: none; border-left: none;" width="127">56</TD></TR><TR><TD class="xl67" height="20" style="border-top: none; border-left: none;" width="125">Jul</TD><TD class="xl67" style="border-top: none; border-left: none;" width="110">0</TD><TD class="xl67" style="border-top: none; border-left: none;" width="127">92</TD></TR><TR><TD class="xl67" height="20" style="border-top: none; border-left: none;" width="125">Aug</TD><TD class="xl67" style="border-top: none; border-left: none;" width="110">0</TD><TD class="xl67" style="border-top: none; border-left: none;" width="127">107</TD></TR><TR><TD class="xl67" height="20" style="border-top: none; border-left: none;" width="125">Sep</TD><TD class="xl67" style="border-top: none; border-left: none;" width="110">96240.15</TD><TD class="xl67" style="border-top: none; border-left: none;" width="127">69</TD></TR><TR><TD class="xl67" height="20" style="border-top: none; border-left: none;" width="125">Oct</TD><TD class="xl67" style="border-top: none; border-left: none;" width="110">0</TD><TD class="xl67" style="border-top: none; border-left: none;" width="127">147</TD></TR><TR><TD class="xl67" height="20" style="border-top: none; border-left: none;" width="125">Nov</TD><TD class="xl67" style="border-top: none; border-left: none;" width="110">0</TD><TD class="xl67" style="border-top: none; border-left: none;" width="127">90</TD></TR><TR><TD class="xl67" height="20" style="border-top: none; border-left: none;" width="125">Dec</TD><TD class="xl67" style="border-top: none; border-left: none;" width="110">0</TD><TD class="xl67" style="border-top: none; border-left: none;" width="127">136</TD></TR></TBODY></TABLE><P></P><P></P><P></P><P>I want the output as :</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="492"><TBODY><TR><TD class="xl65" height="20" width="130">Product_Code</TD><TD class="xl65" style="border-left: none;" width="125">CalendarMonth</TD><TD class="xl66" style="border-left: none;" width="110">StandardCost</TD><TD class="xl66" style="border-left: none;" width="127">Q</TD></TR><TR><TD class="xl68" height="240" rowspan="12" style="border-bottom: .5pt solid silver; border-top: none;" width="130">5002041</TD><TD class="xl67" style="border-top: none; border-left: none;" width="125">Jan</TD><TD class="xl67" style="border-top: none; border-left: none;" width="110">194567.77</TD><TD class="xl67" style="border-top: none; border-left: none;" width="127">93</TD></TR><TR><TD class="xl67" height="20" style="border-top: none; border-left: none;" width="125">Feb</TD><TD class="xl67" style="border-top: none; border-left: none;" width="110">194567.77</TD><TD class="xl67" style="border-top: none; border-left: none;" width="127">108</TD></TR><TR><TD class="xl67" height="20" style="border-top: none; border-left: none;" width="125">Mar</TD><TD class="xl67" style="border-top: none; border-left: none;" width="110">194567.77</TD><TD class="xl67" style="border-top: none; border-left: none;" width="127">114</TD></TR><TR><TD class="xl67" height="20" style="border-top: none; border-left: none;" width="125">Apr</TD><TD class="xl67" style="border-top: none; border-left: none;" width="110">194567.77</TD><TD class="xl67" style="border-top: none; border-left: none;" width="127">92</TD></TR><TR><TD class="xl67" height="20" style="border-top: none; border-left: none;" width="125">May</TD><TD class="xl67" style="border-top: none; border-left: none;" width="110">194567.77</TD><TD class="xl67" style="border-top: none; border-left: none;" width="127">52</TD></TR><TR><TD class="xl67" height="20" style="border-top: none; border-left: none;" width="125">Jun</TD><TD class="xl67" style="border-top: none; border-left: none;" width="110">194567.77</TD><TD class="xl67" style="border-top: none; border-left: none;" width="127">56</TD></TR><TR><TD class="xl67" height="20" style="border-top: none; border-left: none;" width="125">Jul</TD><TD class="xl67" style="border-top: none; border-left: none;" width="110">194567.77</TD><TD class="xl67" style="border-top: none; border-left: none;" width="127">92</TD></TR><TR><TD class="xl67" height="20" style="border-top: none; border-left: none;" width="125">Aug</TD><TD class="xl67" style="border-top: none; border-left: none;" width="110">194567.77</TD><TD class="xl67" style="border-top: none; border-left: none;" width="127">107</TD></TR><TR><TD class="xl67" height="20" style="border-top: none; border-left: none;" width="125">Sep</TD><TD class="xl67" style="border-top: none; border-left: none;" width="110">96240.15</TD><TD class="xl67" style="border-top: none; border-left: none;" width="127">69</TD></TR><TR><TD class="xl67" height="20" style="border-top: none; border-left: none;" width="125">Oct</TD><TD class="xl67" style="border-top: none; border-left: none;" width="110">96240.15</TD><TD class="xl67" style="border-top: none; border-left: none;" width="127">147</TD></TR><TR><TD class="xl67" height="20" style="border-top: none; border-left: none;" width="125">Nov</TD><TD class="xl67" style="border-top: none; border-left: none;" width="110">96240.15</TD><TD class="xl67" style="border-top: none; border-left: none;" width="127">90</TD></TR><TR><TD class="xl67" height="20" style="border-top: none; border-left: none;" width="125">Dec</TD><TD class="xl67" style="border-top: none; border-left: none;" width="110">96240.15</TD><TD class="xl67" style="border-top: none; border-left: none;" width="127">136</TD></TR></TBODY></TABLE></BODY></HTML> Sat, 23 Nov 2013 11:17:07 GMT https://community.qlik.com/t5/QlikView/Repeating-the-values-in-a-straight-table-Pivot-table/m-p/482031#M687285 2013-11-23T11:17:07Z Re: Repeating the values in a straight table/Pivot table https://community.qlik.com/t5/QlikView/Repeating-the-values-in-a-straight-table-Pivot-table/m-p/482032#M687286 <HTML><HEAD></HEAD><BODY><P><STRONG>Manish</STRONG></P><P></P><P>I would look at sorting that in the load script, probably using the <EM>Previous()</EM> and maybe <EM>Order By</EM>, depending on your raw input data.</P><P></P><P></P><P>Best Regards,&nbsp;&nbsp;&nbsp;&nbsp; <STRONG>Bill</STRONG></P></BODY></HTML> Sat, 23 Nov 2013 11:22:11 GMT https://community.qlik.com/t5/QlikView/Repeating-the-values-in-a-straight-table-Pivot-table/m-p/482032#M687286 Anonymous 2013-11-23T11:22:11Z Re: Repeating the values in a straight table/Pivot table https://community.qlik.com/t5/QlikView/Repeating-the-values-in-a-straight-table-Pivot-table/m-p/482033#M687287 <HTML><HEAD></HEAD><BODY><P>As far as Raw data is concerned , i have 2 tables ..</P><P></P><P>First Table looks like :</P><TABLE border="0" cellpadding="0" cellspacing="0" width="265"><TBODY><TR><TD height="20" width="87">ProductCode</TD><TD width="89">Month Year</TD><TD width="89">StandardCost</TD></TR><TR><TD align="right" class="xl66" height="20">5002041</TD><TD align="right" class="xl65">Jan-13</TD><TD align="right" class="xl66">194567.77</TD></TR><TR><TD align="right" class="xl66" height="20">5002041</TD><TD align="right" class="xl65">Sep-13</TD><TD align="right" class="xl66">96240.15</TD></TR></TBODY></TABLE><P></P><P>and Second</P><TABLE border="0" cellpadding="0" cellspacing="0" width="265"><TBODY><TR><TD height="20" width="87">ProductCode</TD><TD width="89">Month Year</TD><TD width="89">Qauntity</TD></TR><TR><TD align="right" class="xl67" height="20">5002041</TD><TD align="right" class="xl66">Jan-13</TD><TD class="xl65" width="89">93</TD></TR><TR><TD align="right" class="xl67" height="20">5002041</TD><TD align="right" class="xl66">Feb-13</TD><TD class="xl65" style="border-top: none;" width="89">108</TD></TR><TR><TD align="right" class="xl67" height="20">5002041</TD><TD align="right" class="xl66">Mar-13</TD><TD class="xl65" style="border-top: none;" width="89">114</TD></TR><TR><TD align="right" class="xl67" height="20">5002041</TD><TD align="right" class="xl66">Apr-13</TD><TD class="xl65" style="border-top: none;" width="89">92</TD></TR><TR><TD align="right" class="xl67" height="20">5002041</TD><TD align="right" class="xl66">May-13</TD><TD class="xl65" style="border-top: none;" width="89">52</TD></TR><TR><TD align="right" class="xl67" height="20">5002041</TD><TD align="right" class="xl66">Jun-13</TD><TD class="xl65" style="border-top: none;" width="89">56</TD></TR><TR><TD align="right" class="xl67" height="20">5002041</TD><TD align="right" class="xl66">Jul-13</TD><TD class="xl65" style="border-top: none;" width="89">92</TD></TR><TR><TD align="right" class="xl67" height="20">5002041</TD><TD align="right" class="xl66">Aug-13</TD><TD class="xl65" style="border-top: none;" width="89">107</TD></TR><TR><TD align="right" class="xl67" height="20">5002041</TD><TD align="right" class="xl66">Sep-13</TD><TD class="xl65" style="border-top: none;" width="89">69</TD></TR><TR><TD align="right" class="xl67" height="20">5002041</TD><TD align="right" class="xl66">Oct-13</TD><TD class="xl65" style="border-top: none;" width="89">147</TD></TR><TR><TD align="right" class="xl67" height="20">5002041</TD><TD align="right" class="xl66">Nov-13</TD><TD class="xl65" style="border-top: none;" width="89">90</TD></TR><TR><TD align="right" class="xl67" height="20">5002041</TD><TD align="right" class="xl66">Dec-13</TD><TD class="xl65" style="border-top: none;" width="89">136</TD></TR></TBODY></TABLE></BODY></HTML> Sat, 23 Nov 2013 11:40:33 GMT https://community.qlik.com/t5/QlikView/Repeating-the-values-in-a-straight-table-Pivot-table/m-p/482033#M687287 2013-11-23T11:40:33Z Re: Re: Repeating the values in a straight table/Pivot table https://community.qlik.com/t5/QlikView/Repeating-the-values-in-a-straight-table-Pivot-table/m-p/482034#M687288 <HTML><HEAD></HEAD><BODY><P><STRONG>Manish</STRONG></P><P></P><P>Is the attached qvw the sort of thing you were after ?</P><P></P><P></P><P>Best Regards,&nbsp;&nbsp;&nbsp;&nbsp; <STRONG>Bill</STRONG></P></BODY></HTML> Sat, 23 Nov 2013 14:58:02 GMT https://community.qlik.com/t5/QlikView/Repeating-the-values-in-a-straight-table-Pivot-table/m-p/482034#M687288 Anonymous 2013-11-23T14:58:02Z