Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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