topic Last Date Value in QlikView

Last Date Value

Fri, 23 Oct 2009 15:40:54 GMT

Hello,

I'm looking for a funktion that selects the value form the last Date entered. I give you an example:

My table looks like this

Part Warehouse Date average price amount

1 10 01.01.2005 2,57 2000

1 10 02.01.2006 2,59 1000

........

1 10 27.10.2009 2,89 1000

I need the following output:

Part Warehouse Date average price amount

1 10 27.10.2009 2,89 1000

Thanks a lot for your help

Last Date Value

Fri, 23 Oct 2009 16:02:27 GMT

Hi,

see the example.

I hope you are looking for this kind of solution.

Good luck!

Rainer

Last Date Value

Mon, 26 Oct 2009 16:01:23 GMT

That kind of solution is exactly what I am looking for. I just would like to have that funktion in the object instead in the script. Is there any possibility?

Thanks

Ulrich

Last Date Value

Mon, 26 Oct 2009 16:43:19 GMT

Hi Ulrich,

see the modified example.

Add a calculated dimension in your table and it works.

But, if you are working with a large data volume the performance will be slowed down.

Rainer

Last Date Value

Mon, 26 Oct 2009 17:03:46 GMT

A possible alternative is to use a set analysis modifier.

Only({<Date = {"=Max(Date)"} >} Amount)

This means "get the amount column, but only having filtered the date column so it's equal to the maximum date".

Hope it helps.

Last Date Value

Mon, 26 Oct 2009 20:08:34 GMT

The Funktion is what I am looking for. All I have to do is to select the Value of the Field "Turnover" at the max date. I don't want to see the sum of that field.

All I need is a row with the Inventory from the 14th Sept 2005. (the table is a lot bigger but I hope with this information I will get it done by myself)

Last Date Value

Anonymous — Tue, 22 Mar 2011 14:45:48 GMT

thanks to Rainer Filoada. I also use this solution.