topic Re: Sum on Absolute date values basis in QlikView

Sum on Absolute date values basis

Tue, 16 Jun 2015 21:13:51 GMT

Hello

I have the followig formula that sum the sales of the prior week:

Sum( {<FECHA = {">=$(=WeekStart(Date(Today()-7))) <=$(=WeekEnd(Date(Today()-7)))"}>} TOT_COMISION_COMPARTIDA)

But when I select a filter, let say May 2015, the sum is not respect me the sum and the graphic dont show me anathig

is any form that this sum always gave me values no matter the date filters I select??

Best Regards

swuehl — Tue, 16 Jun 2015 21:18:54 GMT

Try a set identifier 1 to disregard all selections:

Sum( {1<FECHA = {">=$(=WeekStart(Date(Today()-7))) <=$(=WeekEnd(Date(Today()-7)))"}>} TOT_COMISION_COMPARTIDA)

Alternatively, clear all selections in fields that might interfere with your FECHA modifier, i.e. selections in calendar fields, like Month, Year:

Sum( {<FECHA = {">=$(=WeekStart(Date(Today()-7))) <=$(=WeekEnd(Date(Today()-7)))"}, MonthField=, YearField= >} TOT_COMISION_COMPARTIDA)