topic Set Analysis Last n Weeks in QlikView

Set Analysis Last n Weeks

johnhorneramllp — Fri, 09 Oct 2009 11:59:56 GMT

I am looking at implementing a chart(s) which displays the last n weeks of sales where n will be a variable number (1-12) in column 1 and column 2 will show the previous n weeks. n will be determined by the user using a slider control within the application so the set will have to be variable.

Example 1 - if we are currently in week 26 and the user has selected 6 on the slider then column 1 should show sales for week 21 through 26 (i.e. the last 6 weeks) and column 2 should show sales for weeks 15 through 20 (i.e. the previous 6 weeks).

Hope this makes sense and somebody can help.

Regards

John H

Set Analysis Last n Weeks

Fri, 09 Oct 2009 14:08:20 GMT

Hi Jhorner,

There is my solution using set analysis and one or severals variables.

Best regards.

Set Analysis Last n Weeks

Fri, 09 Oct 2009 16:39:16 GMT

Hi Jhorner,

I think u r expecting this solution.. check the application given .

Miguel i think ur solution is good but Jhorner has asked this in a diff way..

Regards

Ashok