topic Unique record in expression in QlikView

Unique record in expression

alerse — Tue, 07 Jul 2009 12:58:44 GMT

Do you know how to get the last record out of a table to use in an expression?

I've got a table that looks something like this:

L1 L2 Month Actual

Lev1 200906 45.4

Lev1 200905 32.3

I've got this in my help text expression:



=Maxstring(If([L1] = VarL1Out and Isnull([L2]),[Actual]))

How can I get the record for the latest month?

Thanks!

Eon

Unique record in expression

stephencredmond — Tue, 07 Jul 2009 17:21:16 GMT

Hi,

Have you looked at FirstSortedValue:


=firstsortedvalue(Actual, -Month)

Regards,

Stephen

Unique record in expression

alerse — Thu, 16 Jul 2009 13:19:14 GMT

Hi Stephen

Thank you for your input! I couldnt get your solutionto work... I've decided to go a totally different route... I've added actions to Select in field the values I nede to filter on

Regards,

Eon