Discussion board where members can get started with QlikView.
I have a table like the following
Now what i want is to find the latest price of Product by Vendor but with the earliest Date.
I used firstsortedvalue to get the latest price.
My expression is FirstSortedValue([Net price],-[Valid From])
It gives the correct latest net price, but i could not able to Get earliest Date.
Any Ideas ?
Thank you so much in advance.
May be this
Max[Valid From] will give the maximum date but i want the earliest date in which there is max. price