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

set analysis

Hello,

can you help me with this expression plz:

I need to sum the Quantity for which the date is greater than today's date less than one year:

sum({$< DateMVT= {"(>=(date(today()-365)))"}  >} Quantity)

Regards,

Yacine

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Try

sum({$< DateMVT= {">=$(=date(today()-365)))"}  >} Quantity)

DateMVT format should match the standard date format to make this work.

Instead of subtracting 365 days, you could also use addyears() function.

Hope this helps,

Stefan

View solution in original post

2 Replies
swuehl
MVP
MVP

Try

sum({$< DateMVT= {">=$(=date(today()-365)))"}  >} Quantity)

DateMVT format should match the standard date format to make this work.

Instead of subtracting 365 days, you could also use addyears() function.

Hope this helps,

Stefan

Not applicable
Author

the final expression :

=sum({$< DateMVT= {">=$(date(AddYears( today(),-1),'DD/MM/YYYY'))"}  >} Quantity)