topic How to Select Last Record in QlikView

How to Select Last Record

Mon, 23 Nov 2009 20:32:29 GMT

Dear all

I need some help. I need a function which will give me the last record of many different groups.

For example : For the same project I have made 5 actions. I need to take the last ( by date action ) for another project I have made 10 actions I also want to take the last action.

I try to use Last or Max or FirstSortedValue or Top functions but the result isn't ok.

Each project has a unic code.

I looking forward for your help

Thank you very much

Kostas

How to Select Last Record

Mon, 23 Nov 2009 23:49:55 GMT

Hi Kostas,

here are a short script example!

Good luck!

Rainer

How to Select Last Record

Mon, 23 Nov 2009 23:53:00 GMT

Kostas,

and here an example by expression.

It´s in german. Read the expression and see how it works.

Good luck!

Rainer

How to Select Last Record

Tue, 24 Nov 2009 15:30:32 GMT

Thank you very much for your instant responce.

The problem looks like this example.

Opportunity_ID Number_Of_Actions Last_Action_Date Last_Action_Description

001 5 20/11/2009 Meeting with the customer

002 1 23/11/2009 Call customer

For the 001 I have done 5 Actions in different dates. I need to take the last date ( I have no problem with this. I used the MAX function ) and the Last action ( too difficult for me ). If there is only one action it is ok.

Thank you again

Kostas

How to Select Last Record

Fri, 27 Nov 2009 20:40:03 GMT

Hi Kostas,

sorry for the delay!

Here are an example reflecting your data.

Have a nice weekend.

Rainer