topic Simple Function inside Set Analysis in QlikView

Simple Function inside Set Analysis

picturebox — Mon, 29 Nov 2010 18:20:53 GMT

Hello all,

using this code will return the correct values, i.e. vRollWeek1 and vRollWeek2 are correctly interpreted.



sum({$ < WeekIndex = {"> $(vRollWeek1) <= $(vRollWeek2)"} , CW= , SalesMonth= , SalesQuarter=>} UnitMovement )

If I want to increase the vRollWeek1 by some integer, say 1, I thought I could use the syntax:



sum({$ < WeekIndex = {"> $(vRollWeek1)+1 <= $(vRollWeek2)"} , CW= , SalesMonth= , SalesQuarter=>} UnitMovement )

But this syntax does not work. I think it evaluates the first expression to 1. I have tried brackets, inverted commas (double and single..) but I cannot make it work without setting a variable for vRollWeek1+1 and inserting that variable - then it works. This is a bit of a bind though as I get a large number of variables. Can anyone help?

Thanks,

Petra

Simple Function inside Set Analysis

jonathandienst — Mon, 29 Nov 2010 18:29:02 GMT

Petra

Try this:

sum({$ < WeekIndex = {"> $(=vRollWeek1+1) <= $(vRollWeek2)"} , CW= , SalesMonth= , SalesQuarter=>} UnitMovement )

I think that will work.

Jonathan

Simple Function inside Set Analysis

picturebox — Mon, 29 Nov 2010 18:32:05 GMT

Thanks Jonathan,

of course it does! Skipped my brain - it must be Monday.

Best Regards,

Petra

Simple Function inside Set Analysis

Miguel_Angel_Baeyens — Mon, 29 Nov 2010 18:34:12 GMT

Hello Petra,

Did you try?

WeekIndex = {">$(=$(vRollWeek1) +1)<= $(vRollWeek2)"}

Hope this helps