Latest value

[Anonymous]

Hi,

I have a chart with a dimension that can have several values. but i want to show the latest updated value possible in the chart. the values are connected to a date. how do i do this?

can i flag the latest value some how? I'm thinking about the peek function but the problem is that i have several lastest values but for different dimensions too. but maybe that wont be a problem.. or may be my datamodell should be rebuilt :S

Thanks in advance!

[swuehl]

Hi,

maybe you could use my solution for that thread, too:

http://community.qlik.com/thread/34993

Edit:

And yes, I think using the script and previous on a sorted table might be good idea, but maybe you could explain your problem / data model a bit more.

[swuehl]

Hi,

and here is a script approach ...

Regards,

Stefan