topic Comparision with entered dates in QlikView

Comparision with entered dates

Tue, 15 Feb 2011 16:41:00 GMT

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

Comparision with entered dates

pover — Wed, 16 Feb 2011 05:32:13 GMT

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.

Comparision with entered dates

Wed, 16 Feb 2011 10:24:13 GMT

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

Comparision with entered dates

pover — Wed, 16 Feb 2011 18:49:24 GMT

Andy,

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

Regards.

Comparision with entered dates

Wed, 16 Feb 2011 21:24:09 GMT

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

Comparision with entered dates

pover — Thu, 17 Feb 2011 01:47:13 GMT

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.