Get latest value from a field

Fri, 04 Feb 2011 17:45:55 GMT

I have a table like:

ID Type

1 a

2 a

3 b

I have a chart that displays differently depending on what the latest entry in the above table was. So it might look something like this:

if( latest(Type) = a, SUM(something), SUM(something else)

My question is how do I get that Type value into the equation? Thanks!

Fri, 04 Feb 2011 17:52:46 GMT

Hi,

Try this:

if( Only({$<ID={'$(=max(ID))'}>} Type) = a, SUM(something), SUM(something else))

Hope this helps.

Best Regards!

topic Get latest value from a field in QlikView