topic Re: How to pass value in rows to another column in QlikView https://community.qlik.com/t5/QlikView/How-to-pass-value-in-rows-to-another-column/m-p/359637#M704385 <HTML><HEAD></HEAD><BODY><P> Something like this would not be hard.</P></BODY></HTML> Fri, 18 May 2012 21:20:27 GMT 2012-05-18T21:20:27Z How to pass value in rows to another column https://community.qlik.com/t5/QlikView/How-to-pass-value-in-rows-to-another-column/m-p/359636#M704384 <HTML><HEAD></HEAD><BODY><P>Hi, i have this data</P><P></P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="border: 1px solid #000000; width: 315px; height: 120px;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Month<BR /></STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Value<BR /></STRONG></SPAN></TH></TR><TR><TD><P>201205</P></TD><TD>200</TD></TR><TR><TD>201204</TD><TD>100</TD></TR><TR><TD>201203</TD><TD>50</TD><TD><BR /></TD></TR><TR><TD>201202</TD><TD>100</TD></TR></TBODY></TABLE><P></P><P>I want manipulate the data and pass to one row, like this</P><P></P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="border: 1px solid #000000; width: 496px; height: 95px;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Month<BR /></STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Current<BR /></STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Month-1<BR /></STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Month-2<BR /></STRONG></SPAN></TH></TR><TR><TD>201205</TD><TD>200</TD><TD>100</TD><TD>50</TD></TR><TR><TD>201204</TD><TD>100</TD><TD>50</TD><TD>100</TD></TR><TR><TD>201203</TD><TD>50</TD><TD>100</TD><TD>0</TD></TR></TBODY></TABLE><P></P><P>The idea is have the current value and the last 4 months.</P><P></P><P>¿Any suggestions?</P><P></P><P>Thanks in advance</P><P></P><P>Julian</P></BODY></HTML> Fri, 18 May 2012 20:47:34 GMT https://community.qlik.com/t5/QlikView/How-to-pass-value-in-rows-to-another-column/m-p/359636#M704384 julian_ortiz 2012-05-18T20:47:34Z Re: How to pass value in rows to another column https://community.qlik.com/t5/QlikView/How-to-pass-value-in-rows-to-another-column/m-p/359637#M704385 <HTML><HEAD></HEAD><BODY><P> Something like this would not be hard.</P></BODY></HTML> Fri, 18 May 2012 21:20:27 GMT https://community.qlik.com/t5/QlikView/How-to-pass-value-in-rows-to-another-column/m-p/359637#M704385 2012-05-18T21:20:27Z Re: How to pass value in rows to another column https://community.qlik.com/t5/QlikView/How-to-pass-value-in-rows-to-another-column/m-p/359638#M704386 <HTML><HEAD></HEAD><BODY><P>I think this is what you did imply</P></BODY></HTML> Sat, 19 May 2012 03:21:35 GMT https://community.qlik.com/t5/QlikView/How-to-pass-value-in-rows-to-another-column/m-p/359638#M704386 2012-05-19T03:21:35Z How to pass value in rows to another column https://community.qlik.com/t5/QlikView/How-to-pass-value-in-rows-to-another-column/m-p/359639#M704387 <HTML><HEAD></HEAD><BODY><P>Thanks for help me Nick. Regards</P></BODY></HTML> Wed, 23 May 2012 15:46:16 GMT https://community.qlik.com/t5/QlikView/How-to-pass-value-in-rows-to-another-column/m-p/359639#M704387 julian_ortiz 2012-05-23T15:46:16Z How to pass value in rows to another column https://community.qlik.com/t5/QlikView/How-to-pass-value-in-rows-to-another-column/m-p/359640#M704388 <HTML><HEAD></HEAD><BODY><P>Thanks for help me. Regards</P></BODY></HTML> Wed, 23 May 2012 15:46:47 GMT https://community.qlik.com/t5/QlikView/How-to-pass-value-in-rows-to-another-column/m-p/359640#M704388 julian_ortiz 2012-05-23T15:46:47Z