topic Filtering for multiple date function... in QlikView https://community.qlik.com/t5/QlikView/Filtering-for-multiple-date-function/m-p/226818#M78984 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Could any one help me with the below req:</P><P>I have a table with</P><P></P><P>// ID,</P><P>BatchNUM,</P><P>//P.TYPE,</P><P>// AreaCODE,</P><P>DATE1,</P><P>DATE2,</P><P>STATUS_RATE</P><P>fields. Here the status of P.TYPE are checked randomly and rated. I have to sum the P.TYPE with similar rating. One more thing is, to take the Date1 or Date2 which ever the latest.</P><P>The data is from 2006 to 2011, I have to filter the 2011 data from this table to a different table using resident load.</P><P>What calender will best suit for this scenario to know the status of F.Type between two random dates.</P><P>Any ideas will be appreciated.</P><P></P><P></P><P></P></BODY></HTML> Fri, 22 Apr 2011 05:47:34 GMT 2011-04-22T05:47:34Z Filtering for multiple date function... https://community.qlik.com/t5/QlikView/Filtering-for-multiple-date-function/m-p/226818#M78984 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Could any one help me with the below req:</P><P>I have a table with</P><P></P><P>// ID,</P><P>BatchNUM,</P><P>//P.TYPE,</P><P>// AreaCODE,</P><P>DATE1,</P><P>DATE2,</P><P>STATUS_RATE</P><P>fields. Here the status of P.TYPE are checked randomly and rated. I have to sum the P.TYPE with similar rating. One more thing is, to take the Date1 or Date2 which ever the latest.</P><P>The data is from 2006 to 2011, I have to filter the 2011 data from this table to a different table using resident load.</P><P>What calender will best suit for this scenario to know the status of F.Type between two random dates.</P><P>Any ideas will be appreciated.</P><P></P><P></P><P></P></BODY></HTML> Fri, 22 Apr 2011 05:47:34 GMT https://community.qlik.com/t5/QlikView/Filtering-for-multiple-date-function/m-p/226818#M78984 2011-04-22T05:47:34Z Filtering for multiple date function... https://community.qlik.com/t5/QlikView/Filtering-for-multiple-date-function/m-p/226819#M78985 <HTML><HEAD></HEAD><BODY><P>Could any one suggest any answer..</P><P>Thanks</P></BODY></HTML> Sat, 23 Apr 2011 07:47:38 GMT https://community.qlik.com/t5/QlikView/Filtering-for-multiple-date-function/m-p/226819#M78985 2011-04-23T07:47:38Z