Set and Sales Analyais between past and post for given week

[#1]

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

                                Vs

                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,

[#2]

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)

[sunny_talwar]

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.