Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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

Tags (2)
1 Solution

Accepted Solutions
MVP
MVP

Re: set analysis

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

2 Replies
MVP
MVP

Re: set analysis

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

Re: set analysis

the final expression :

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

Community Browser