topic Re: sales if statement based on variable in QlikView

sales if statement based on variable

Mon, 30 Dec 2013 15:26:00 GMT

hi i have the following statement

sum(if([Year Week]=weekyear(today()-7)&num(week(today()-((7 * $(OrderVeckor))

)),00),[Order Quantity],0))

$(OrderVeckor) = 7

201346 - 201401

i wish to calculate the Orderquantity for the last 7 weeks.

my statement however is wrongly formulated, any suggestions.

Best

Brad

bbi_mba_76 — Mon, 30 Dec 2013 16:03:27 GMT

Hi,

I'm not sure, maybe something like this?

sum(if([Year Week]>=

weekyear(today()-(7 * $(OrderVeckor)))&num(week(today()-(7 * $(OrderVeckor))),00)

,[Order Quantity],0))

Where are you calculate this value, script or expression?

If you could attach the qvw, it is better