topic Get the Last previous date value in QlikView

Get the Last previous date value

Wed, 08 Feb 2012 06:31:50 GMT

Dear All,

I need a solution for this query,

utput : If I select the date 10-sep-2011 then I should get the value for 07-sep-2011(200)

Regards,

Ravi.

jagan — Wed, 08 Feb 2012 06:58:25 GMT

Hi,

Try this, hope this helps you.

= Date(Max({<DateField={'<$(=Date(Max(DateField)))'}>} DateField))

Regards,

Jagan.

CELAMBARASAN — Wed, 08 Feb 2012 07:09:27 GMT

Hi,

try with this expression,

=FirstSortedValue({<Date={"<$(=Date)"}>} Value,-Date)

It works perfectly if the date is selected.

Hope it helps

Celambarasan