topic Set Analysis question , need a > then expression in QlikView

Set Analysis question , need a > then expression

Sat, 06 Jun 2009 00:13:28 GMT

Hi,

Trying to write a set analysis statement but can't seem to find the correct syntax. Trying to do a rolling average based on week of year. User select the number of weeks to include and I want to select all week greater thenthe current week of year - the number of week to include

avg( {1<[Week of Yr] >= { $(#=week(Now())- $(numweeks)) } > } [2009 sales figures])

It works perfectly for a single week, but when I add the > I get all weeks of 2009.

Thanks In Advance

Michael

Set Analysis question , need a > then expression

johnw — Sat, 06 Jun 2009 02:14:26 GMT

You have to do the >= in the set expression itself. I think it would look like this:

avg({1<[Week of Yr]={">=$(=week(now())-$(numweeks))"}>} [2009 sales figures])

Set Analysis question , need a > then expression

Sat, 06 Jun 2009 02:44:10 GMT

thanks John!

that did it