topic How not to select certain values from table in QlikView https://community.qlik.com/t5/QlikView/How-not-to-select-certain-values-from-table/m-p/311384#M1198068 <HTML><HEAD></HEAD><BODY><P>Hi! I've just started to use Qlikview and done some progress with it. Now I have this question about QV functionality.</P><P>I have a table</P><P>ID Date1 Date2 Value1</P><P>1 16.10.2009 13.11.2009 28</P><P>2 28.10.2009 25.11.2009 28</P><P>3 16.11.2009 14.12.2009 28</P><P>4 9.12.2009 6.1.2010 28</P><P></P><P>Value 1 is Date2 - Date1</P><P>How can I load this table without selecting Date1 values which are smaller then Date2</P><P>Example: ID1 has Date2 of 13.11.2009 so I don't want to select ID2 which Date1 is smaller then 13.11.2009. But I want to select ID3 which Date1 is greater then ID1's Date2.</P><P>Thank you!</P><P>-Mikael</P></BODY></HTML> Tue, 08 Mar 2011 13:37:57 GMT 2011-03-08T13:37:57Z How not to select certain values from table https://community.qlik.com/t5/QlikView/How-not-to-select-certain-values-from-table/m-p/311384#M1198068 <HTML><HEAD></HEAD><BODY><P>Hi! I've just started to use Qlikview and done some progress with it. Now I have this question about QV functionality.</P><P>I have a table</P><P>ID Date1 Date2 Value1</P><P>1 16.10.2009 13.11.2009 28</P><P>2 28.10.2009 25.11.2009 28</P><P>3 16.11.2009 14.12.2009 28</P><P>4 9.12.2009 6.1.2010 28</P><P></P><P>Value 1 is Date2 - Date1</P><P>How can I load this table without selecting Date1 values which are smaller then Date2</P><P>Example: ID1 has Date2 of 13.11.2009 so I don't want to select ID2 which Date1 is smaller then 13.11.2009. But I want to select ID3 which Date1 is greater then ID1's Date2.</P><P>Thank you!</P><P>-Mikael</P></BODY></HTML> Tue, 08 Mar 2011 13:37:57 GMT https://community.qlik.com/t5/QlikView/How-not-to-select-certain-values-from-table/m-p/311384#M1198068 2011-03-08T13:37:57Z