topic Re: use ranked date in expression in QlikView

use ranked date in expression

curiousfellow — Wed, 28 Oct 2015 12:06:45 GMT

I have a table with several calenderdates and results.

Now I want to display the results of the second highest calenderdate.

My expression : Sum({$<rank(calenderdate)={$(=2)}>}results ) does not give any results.

And again i do not understand why

Re: use ranked date in expression

sunny_talwar — Wed, 28 Oct 2015 12:11:29 GMT

May be this:

=Sum({<calenderdate = {"$(=Date(Max(calendardate, 2),'YourcalendardateFieldFormatHere'))"}>}results)

Re: use ranked date in expression

Kushal_Chawda — Wed, 28 Oct 2015 12:23:03 GMT

=Firstsortedvalue (results , - calenderDate, 2)

Re: use ranked date in expression

Marcos112 — Thu, 30 Mar 2023 16:12:15 GMT

Hi Sunny

I'm using the rank function that gives me the expected result, the problem is when I filter by a date, the rank returns to 1, so I need it to ignore the selection of that field(Fecha)

Can you help me? Thanks in advance