Top 5

[#1]

Hi,

I am using the expresssion

=Count(If(Rank(Count(IF((FROM_TIME>=(MakeDate(Year(Today()-7),Month(Today()-7),Day(Today()-7))) and (FROM_TIME<=(MakeDate(Year(Today()-1),Month(Today()-1),Day(Today()-1))))),ID_) ),4,2)<=5,ID))

to display the top 5. But it is not displaying any values.

[#2 · Accepted solution]

Hi,

I got the solution from the post

http://community.qlik.com/forums/p/39906/157392.aspx#157392