Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Specialist II
Specialist II

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.

Highlighted
Not applicable

Take week as dimension, and try to use expression:

firstsortedvalue(distinct sales,-transaction_date)

Let me know if it works.

regards

Darek