topic Re: Extract a previous record from a table in QlikView https://community.qlik.com/t5/QlikView/Extract-a-previous-record-from-a-table/m-p/463728#M562220 <HTML><HEAD></HEAD><BODY><P>Thanks Gysbert Wassenaar</P></BODY></HTML> Thu, 28 Mar 2013 06:20:10 GMT 2013-03-28T06:20:10Z Extract a previous record from a table https://community.qlik.com/t5/QlikView/Extract-a-previous-record-from-a-table/m-p/463726#M562216 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have table where in the data is as follows</P><P></P><P>Table-1</P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle">ID<BR /></TH><TH align="center" style="background-color: #6690bc;" valign="middle">Date<BR /></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Value</STRONG></SPAN></TH></TR><TR><TD>Comp1</TD><TD>01-jan-2011</TD><TD>AA</TD></TR><TR><TD>Comp1</TD><TD>01-sep-2011</TD><TD>AAA</TD></TR><TR><TD>Comp1</TD><TD>01-jan-2012</TD><TD>BB</TD></TR><TR><TD>Comp1</TD><TD>01-sep-2013</TD><TD>C</TD></TR><TR><TD>Comp2</TD><TD>01-jan-2011</TD><TD>BB</TD></TR><TR><TD>Comp2</TD><TD>01-jan-2012</TD><TD>AAA</TD></TR><TR><TD>Comp2</TD><TD>01-sep-2012</TD><TD>A</TD></TR><TR><TD>Comp2</TD><TD>01-sep-2013</TD><TD>BB</TD></TR><TR><TD>Comp3</TD><TD>01-jan-2011</TD><TD>AAA</TD></TR><TR><TD>Comp3</TD><TD>01-sep-2011</TD><TD>D</TD></TR><TR><TD>Comp3</TD><TD>01-jan-2013</TD><TD>AA</TD></TR><TR><TD>Comp3</TD><TD>01-sep-2013</TD><TD>AA</TD></TR></TBODY></TABLE><P></P><P>I need to extract data as follows, how its possible</P><P></P><P>Table-2</P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>ID</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle">Previous Value<BR /></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Present Value</STRONG></SPAN></TH></TR><TR><TD>Comp1</TD><TD>BB</TD><TD>C</TD></TR><TR><TD>Comp2</TD><TD>A</TD><TD>BB</TD></TR><TR><TD>Comp3</TD><TD>D</TD><TD>AA</TD></TR></TBODY></TABLE><P></P><P>The data is stored as in table 1, i need to create a chart where the value that is current or value which is lastest should show in one column and value before it changes to the current value should be displayed in another column</P></BODY></HTML> Thu, 21 Mar 2013 08:08:31 GMT https://community.qlik.com/t5/QlikView/Extract-a-previous-record-from-a-table/m-p/463726#M562216 2013-03-21T08:08:31Z Re: Extract a previous record from a table https://community.qlik.com/t5/QlikView/Extract-a-previous-record-from-a-table/m-p/463727#M562218 <HTML><HEAD></HEAD><BODY><P>See attached qvw</P></BODY></HTML> Thu, 21 Mar 2013 10:22:58 GMT https://community.qlik.com/t5/QlikView/Extract-a-previous-record-from-a-table/m-p/463727#M562218 Gysbert_Wassenaar 2013-03-21T10:22:58Z Re: Extract a previous record from a table https://community.qlik.com/t5/QlikView/Extract-a-previous-record-from-a-table/m-p/463728#M562220 <HTML><HEAD></HEAD><BODY><P>Thanks Gysbert Wassenaar</P></BODY></HTML> Thu, 28 Mar 2013 06:20:10 GMT https://community.qlik.com/t5/QlikView/Extract-a-previous-record-from-a-table/m-p/463728#M562220 2013-03-28T06:20:10Z