Getting Last Record

Tue, 17 Nov 2015 19:30:18 GMT

We have Excel data that records inventory levels of various work queues. We are trying to create a series of QlikView gauges that display the ending inventory for the latest date posted for each of the queues. In general the data looks like this:

TransDate	Queue	StartingInv	EndingInv
1/11/15	Queue1	1200	987
1/12/15	Queue1	987	484
1/13/15	Queue1	484	528
1/11/15	Queue2	8965	8709
1/12/15	Queue2	8709	8488
1/13/15	Queue2	8488	8564
1/14/15	Queue2	8564	8876

So the first gauge would display (for Queue1) the value of 528 and the second gauge would display (for Queue2) the value of 8876 both representing the latest dates for their respective queues. Wed tried various expressions using PEEK like this:

=If(Peek(Queue)='Queue1',Peek([Ending Inv]),-1)

but were unsuccessful. Any help would be appreciated. Thanks!!

Re: Getting Last Record

flochi75 — Mon, 07 Dec 2015 13:08:49 GMT

salut Eric,

Je ne sais pas si ta demande est toujours d'actualité mais tu veux ça:

Tu peux le faire ainsi :

Et dans ton tableau avec Queue en dimension, l'expression suivante de donnera la valeur par Queue de la date max :

Cordialement,

Florent.

topic Re: Getting Last Record in QlikView

Getting Last Record

Re: Getting Last Record