topic How to query data in the same table in QlikView

topic How to query data in the same table in QlikView https://community.qlik.com/t5/QlikView/How-to-query-data-in-the-same-table/m-p/482792#M1146923 <HTML><HEAD></HEAD><BODY><P>I want to query data in the same table.</P><P></P><P></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>Date</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Product</STRONG></SPAN></TH></TR><TR><TD><P><SPAN style="font-size: 10pt;">20-JUL-13</SPAN></P></TD><TD>REP</TD></TR><TR><TD>30-JUL-13</TD><TD>REV</TD></TR><TR><TD>15-DEC-13</TD><TD>REP</TD></TR><TR><TD>12-DEC-13</TD><TD>REV</TD></TR><TR><TD>13-DEC-13</TD><TD>REV</TD></TR></TBODY></TABLE><P></P><P>My expected algorithm is:</P><P>1. Match all REP with REV and date < 30 days from today and mark that as 'MATCH'</P><P>2. Match all REP with REV and date > 30 days from today and mark that as 'UNMATCH'</P><P></P><P>How can I do this in QV?</P></BODY></HTML> Mon, 15 Jul 2013 22:10:30 GMT 2013-07-15T22:10:30Z How to query data in the same table https://community.qlik.com/t5/QlikView/How-to-query-data-in-the-same-table/m-p/482792#M1146923 <HTML><HEAD></HEAD><BODY><P>I want to query data in the same table.</P><P></P><P></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>Date</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Product</STRONG></SPAN></TH></TR><TR><TD><P><SPAN style="font-size: 10pt;">20-JUL-13</SPAN></P></TD><TD>REP</TD></TR><TR><TD>30-JUL-13</TD><TD>REV</TD></TR><TR><TD>15-DEC-13</TD><TD>REP</TD></TR><TR><TD>12-DEC-13</TD><TD>REV</TD></TR><TR><TD>13-DEC-13</TD><TD>REV</TD></TR></TBODY></TABLE><P></P><P>My expected algorithm is:</P><P>1. Match all REP with REV and date < 30 days from today and mark that as 'MATCH'</P><P>2. Match all REP with REV and date > 30 days from today and mark that as 'UNMATCH'</P><P></P><P>How can I do this in QV?</P></BODY></HTML> Mon, 15 Jul 2013 22:10:30 GMT https://community.qlik.com/t5/QlikView/How-to-query-data-in-the-same-table/m-p/482792#M1146923 2013-07-15T22:10:30Z