topic Re: Maximum date in QlikView

Maximum date

Wed, 28 May 2014 12:00:40 GMT

Hi,

I have two partners in my dataset, i need to consider the latest transaction date in a week and its corresponding sales value.

Thank you.

Anonymous — Wed, 28 May 2014 12:03:05 GMT

you can use expression as :

sum({$<[Transaction Date]=$(=date(max([Transaction Date])))>}Sales)

Please note [Transaction Date] should be in date format or you can use this field after converting it to numeric values and then use it.

Wed, 28 May 2014 12:20:50 GMT

Take week as dimension, and try to use expression:

firstsortedvalue(distinct sales,-transaction_date)

Let me know if it works.

regards

Darek