Set and Sales Analyais between past and post for given week

Wed, 09 Mar 2016 04:11:12 GMT

Hi Guys,

Looking for expression to derive some set and sales analysis results using slider as variable define.

Here is what i am looiking for, its bit tricky when we pass the week 20152.

Week Sales Stores

201545 $70.00 E

201546 $40.14 EP

201547 $71.00 E

201548 $57.74 EP

201549 $87.00 E

201550 $70.00 EP

201551 $23.00 E

201552 $60.00 EP

201601 $44.89 E

201602 $52.20 EP

201603 $90.00 E

201604 $30.44 EP

201605 $80.70 E

201606 $40.00 E

201607 $58.00 EP

201608 $60.00 E

201609 $45.00 EP

Stores Avg 4Weeks Post

Avg 2Weeks Previous By %

E +7.8% (sum(<week = 201552,20151,210550,201549">) - sum(<week = "201602,201603">))

EP +4.2% (sum(<week = 201552,20151,210550,201549">) - sum(<week = "201602,201603">))

Basically user will select the week and using slider they will define the Avg number of weeks for Post and previous weeks separately, I need to compare the Stores performance by summing the sales between those weeks at given selected week .

sum(<week = 201552,20151,210550,201549">) sum(<week = "201602,201603">)

<--------------------------------------------------------------------------201601----------------------------------------------------------->

Any idea much appreciated.

Regards,

Re: Set and Sales Analyais between past and post for given week

Wed, 09 Mar 2016 12:03:47 GMT

Hi durga

I hope this will works

Step:1 Take slider object and give field week to the slider object.

Step2: Create variable in variable overview and give only(WEEK).

Step3. In expression take sum({<Week={'$(VariableName)'}>}Sales)

Re: Set and Sales Analyais between past and post for given week

sunny_talwar — Wed, 09 Mar 2016 14:17:48 GMT

Do you have a sample qvw where you have been testing it out? It would be much easier to see what you are doing and recommend changes rather than starting from scratch for your particular scenario since you have a bunch of sliders etc.

topic Re: Set and Sales Analyais between past and post for given week in QlikView

Set and Sales Analyais between past and post for given week

Re: Set and Sales Analyais between past and post for given week

Re: Set and Sales Analyais between past and post for given week