topic Re: Get last payment in QlikView

Get last payment

Mon, 17 Jun 2013 06:29:04 GMT

I do have a problem with getting the following in qlikview.
I need to create a table with the following information: Last amount of payment by customer.

It is not a solution to maintain the last payment in the script because the table must react on selections made by the user.

Can someone please help me?

Re: Get last payment

kumarnatarajan — Mon, 17 Jun 2013 06:37:33 GMT

try this.

Ex: FirstSortedValue(AmountFieldName,-DateFieldName)

Re: Get last payment

Mon, 17 Jun 2013 06:47:48 GMT

On the basis of maximum date you can find the last Amount of Payment.

there are various way to find it either at script label or expression label.

In expression label--

Take pivote--

dimension-- your primary key field

expression--

FirstSortedValue(AmountFieldName,-DateFieldName)

******************************************************

in text object--

if(date(DateFieldName,'DD-MM-YYYY')=max(DATE(DateFieldName,'DD-MM-YYYY')),AmountFieldName)