Get last payment

[#1]

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?

[kumarnatarajan · Accepted solution]

Hi

try this.

Ex: FirstSortedValue(AmountFieldName,-DateFieldName)

[#3]

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)