Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
davyqliks
Creator III
Creator III

Sum Value for max date

Hi

I hope you may be able to assist with another small issue.

I have not used max Date before and always fixed data with set.

I have sorted my date import calendar and want to implement some dynamic date fields in tables.

when i use the following i am getting the max date returned

Date(Max([Voucher Date]))

 

I would like to use this with a basic sum  of

Sum(HKD_Price)

But i am struggling to get a result when trying to glue the 2 together

Can you assist with this?

Thank you in advance

Daniel

Labels (1)
1 Solution

Accepted Solutions
tresesco
MVP
MVP

Try like:

 

Sum({<[Voucher Date]={'$(=Date(Max([Voucher Date])))'}>} HKD_Price)

View solution in original post

3 Replies
tresesco
MVP
MVP

Try like:

 

Sum({<[Voucher Date]={'$(=Date(Max([Voucher Date])))'}>} HKD_Price)

View solution in original post

davyqliks
Creator III
Creator III
Author

Hey,

Thanks so much, giving this a try now and will reply shortly.

Daniel

davyqliks
Creator III
Creator III
Author

HI,

Thanks again,

had some issue with the Voucher date but the syntax is perfect with Year instead.

This is great and gives me something to work with.

Thank you so much

Daniel