Comparision with entered dates

[#1]

Hello,

I am new to QV and has this general question while working with input boxes and set analysis. My client has promotions running sometimes a week or more. They want to have 3 input boxes, where in they can enter the week numbers Pre, Current, Post sales of the promotion. In general if they select say week 6, 7, 8 in current and they select 4,5 in Pre and 9,10 in Post week selections, the chart should show the data. Can anyone help me with the best approach for this?? If I need variables or can be achieved using Set Analysis without variables...? I think this is a general query but unable to find a solution for this exact requirement I have here.

Thanks a Ton in Advance,

ANDY

[pover]

Andy, See the attached file to see if I understood what you are looking for. I created a slider object that is mult-variable so you define a variable that is the min value and another that is the max value. I then used those variables in an expression with set analysis to filter the right weeks. Tell me if you have any questions.

Regards.

[#3]

Hello Karl,

Thank you for the response and the file. However my problem is that the client wants an input box say I create 3 variables, Pre, Current, Post for promotions and my client wants to enter week numbers for these 3 values to calculate the sales. I have done that as well, but now my question is how can I do a Variable which accepts more than one week number and sums up the sales. EG: Pre - 3 Selected Weeks, Current - 3 selected weeks, post - 3 selected weeks, Currently I have a input box which does it for one week.

Any suggestions, and Thanks again in advance for your time 🙂

ANDY

[pover]

Andy,

Here's the same example using an inputbox to enter in the weeks.

Regards.

[#5]

Hello Karl,

Thank you for taking the time to send the QVW really appreciate that. But I think what I am trying to achieve is something as shown in the image, I actually had another post with the same issue, thought would close this but still trying as I dint get any solution yet.

Well I am looking for something like, when I select more than 3 weeks(by creating a variable and entering one value I can do it) this should calculate the average sales for that. So that in the chart I should have something like if I select Pre promotion 3,4,5 weeks, during promotion 6,7 weeks and post promotion 8,9,10 weeks, so it would be 3+2+3 columns showing the average sales for the respective weeks

[pover]

Here you go again with another example. You can't select more than one value in a variable, so create 3 table islands that contain the week numbers and use those field to filter the expressions.

Regards.