It's possible to get a max value of a max date of one ID using expressions in QlikView?
|ID||Max Date||Max Value|
Great solution .. However I didn't understand, in the FirstSortedValue function, why would we need to use (Date*1000+Value) as sort weight .. I was assuming it would sort just by using 'Date' here.
Could you please explain this logic.. I am quite confused.
Trying to sort just based on date will give you two max values for each ID. But we want the max value for max date. This is double sorting, which isn't available within FirstSortedValue. So in order to do double sorting, we are trying to sort based on Date 1st (mutiplying is by 10000 to give it higher wait) and second by Value itself (multiplying by 1 to give it lower weight)
I have a similar question. I am trying to create a calculated dimension in which I need to consider (distinct max date and distinct Name_String) ?