https://community.qlik.com/t5/QlikView/Display-most-recent-data-between-date-ranges/m-p/1748430#M453465 <P>check out attached</P><P>what i did was compare the max(date) per outcome vs max date per outcome and rank, if they are the same, then it is the latest RANK per outcome</P> Wed, 30 Sep 2020 12:05:03 GMT edwin 2020-09-30T12:05:03Z https://community.qlik.com/t5/QlikView/Display-most-recent-data-between-date-ranges/m-p/1745298#M453266 <P>I wanted to display the most recent count between date ranges .... IF I select to arrange the record may bot have the rank =1&nbsp; but maybe rank 3 in that date range. I need to display the record that is latest based (rank column have values including all records into consideration). I have attached my solution,, could you please help how to achieve the values?</P><P>=count(if(Date&gt;=vStartDate and Date&lt;=vEndDate and rnk=1 ,KeyProfile)) ..if I use this condition I'm missing records that created within date range.. so I need to get the most recent rank by selected date range.</P> Sun, 20 Sep 2020 00:37:35 GMT https://community.qlik.com/t5/QlikView/Display-most-recent-data-between-date-ranges/m-p/1745298#M453266 Sai78 2020-09-20T00:37:35Z https://community.qlik.com/t5/QlikView/Display-most-recent-data-between-date-ranges/m-p/1748430#M453465 <P>check out attached</P><P>what i did was compare the max(date) per outcome vs max date per outcome and rank, if they are the same, then it is the latest RANK per outcome</P> Wed, 30 Sep 2020 12:05:03 GMT https://community.qlik.com/t5/QlikView/Display-most-recent-data-between-date-ranges/m-p/1748430#M453465 edwin 2020-09-30T12:05:03Z