topic Re: set analysis in QlikView

set analysis

Thu, 27 Sep 2012 16:33:19 GMT

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

swuehl — Thu, 27 Sep 2012 16:49:22 GMT

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

Fri, 28 Sep 2012 08:43:19 GMT

the final expression :

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