topic Re: Re: value from last record- dynamic in QlikView

value from last record- dynamic

Sun, 08 Jun 2014 11:44:03 GMT

Hi all,

I have a table of transaction.

I would like to get the last price for each item, within a dynamic period of time.

e.g.,

if the table is:

Item Date Price

x 30-Apr-14 10

y 02-May-14 9

y 15-May-14 8.5

x 17-May-14 12

y 28-May-14 11

x 29-May-14 15

y 02-Jun-14 14

and the user selects May 2013.

The outcome i'm looking for is:

Item Last Price

x 15

y 11

How can i achieve this?

Thanks.

Anonymous — Sun, 08 Jun 2014 11:53:07 GMT

Assuming it is a straight table where Item is a dimension, try this:

=FirstSortedValue(Price, -Date)

Sun, 08 Jun 2014 23:00:35 GMT

Michael's suggestion works perfectly. See attached.

Sun, 08 Jun 2014 23:29:25 GMT

Thanks guys,

I'll check it in a few days.