topic help with expression in QlikView

help with expression

Wed, 07 Apr 2010 22:18:58 GMT

Please help with my expression.

I am trying to get a sum of previous year to date sales.

if(date([INVC DATE])=yeartodate([INVC DATE],-1),SUM([TOT AMT]), 0)

Once i get this right I will make it a flag in my Load but for now I am testing it as an expression

Any help is much appreciated

mike_garcia — Wed, 07 Apr 2010 22:24:36 GMT

I believe you dont need to make a comparison, just use:

if(yeartodate([INVC DATE],-1),SUM([TOT AMT]), 0)

Regards,

Mike.

boorgura — Wed, 07 Apr 2010 22:26:38 GMT

Hey,

do you want to try this:

if(year2date([INVC DATE], -1), sum(TOT AMT), 0)

Wed, 07 Apr 2010 22:35:37 GMT

Neither suggestions worked. Both outputted 0 but I have data ranging four years.

johnw — Wed, 07 Apr 2010 22:58:54 GMT

I believe you just need to switch the if() to inside the sum():

sum(if(yeartodate([INVC DATE],-1),[TOT AMT]))

Wed, 07 Apr 2010 23:06:44 GMT

Works with this, thanks John!