Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Sum Values using the addyears function with date format MM/DD/YYYY

I am attempting to sum a value of a column of data using the date with a format of MM/DD/YYYY.  I am using the following expression and having no luck.

=Sum({$<[POS Date]={"$(=addyears(Date(Max([POS Date]),'MM/DD/YYYY'),-1))"}>}[POS Adjusted Fair Value])

Any help would be appreciated.

17 Replies
sunny_talwar

Can you try this one for your second expression??

=Sum({$<[POS Date]={"$(=Num(AddYears(Date(Max([POS Date])), -1)))"}>}[POS Adjusted Fair Value])

Not applicable
Author

That did not work.

sunny_talwar

Can you share a sample application to look at?

Best,

Sunny

Not applicable
Author

Sunny,

Let me play around with it a bit and see if I can get it to work.  Thanks for your assistance.

sunny_talwar

Not a problem, I wish I was more helpful. Let me know if you don't find any way to fix it.

Best,

Sunny

Not applicable
Author

Thanks, you were very helpful.  Just need to play around with it a bit.

Not applicable
Author

Sunny,

Thanks, I was able to get it to work with a little bit of effort.  Your answer was correct.

sunny_talwar

Awesome! I am glad we were finally able to figure it out.

Best,

Sunny