Discussion board where members can get started with QlikView.
I have a table with purchase data.
Now I only want to return the latest purchase price in a pivot table.
I made this function:
--> purchasenumber is the unique number of the purchasedocuments, so the highest number (max) is the latest document.
I get a "-" as result in my pivot table, when I select the latest purchasedocument in a selection box than it returns the correct value!
What am I doing wrong?
Try using FirstSortedValue(), like:
View solution in original post
Thx, this gives the correct value!