Table shown parts, customer and last sorted prize

[NikolaNikolic]

Hello,

i am new to Qlikview and have a problem!

i have a table with: parts, customer, prize and date

i need to show a table with the last prize for each part and customer.

[Steven35]

Hello,

If we have:

Then you would have:

You need to use "FirstSortedValue" : https://help.qlik.com/fr-FR/sense/November2022/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/Basic...

LastDate = FirstSortedValue(date,-date)

LastPrize = FirstSortedValue(prize,-date)

Best regards,

Steven