Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Sai78
Contributor III
Contributor III

Display most recent data between date ranges

I wanted to display the most recent count between date ranges .... IF I select to arrange the record may bot have the rank =1  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?

=count(if(Date>=vStartDate and Date<=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.

1 Reply
edwin
Master II
Master II

check out attached

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