Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Maximum date

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.

2 Replies
gupta_n8
Valued Contributor II

Re: Maximum date

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.

Not applicable

Re: Maximum date

Take week as dimension, and try to use expression:

firstsortedvalue(distinct sales,-transaction_date)

Let me know if it works.

regards

Darek

Community Browser