Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Run Rate Algorithm

I am looking for assistance in coding the following tables run rate based on sporadic weekly sales data. The data is available as daily sales volume by customer and by product

I'm not sure this is possible as the run rate would be required for each product customer combination by day but any alternative ideas on run rates for data sets of this size and complexity would be welcome.

Essentially

Calc 1: starting point no prior data therefore no run rate

Calc 2: no promo sales so run rate is total of that week for std sales only

Calc 3 :both promo and std sales so total of both for that week = run rate

Calc 4: no Std sales so run rate is total of that week for promo sales only

Calc 5: no sales so last week containing sales would calculate as the run rate (so if no sales for two months then the sales from the last point of sale would be used)


My table below would therefore not contain columns for std and promo merely a run rate for each week for each product and customer.

     

ProductWeekStd SalesPromo SalesRun Rate
1wk32001000
1wk43000300
1wk5100200300
1wk62000200
1wk7100100200
1Wk83000300
1Wk900300
2wk44500450
2wk5150300450
2wk63000300
2wk7150150300
2Wk84500450
2Wk900450
3wk36003000
3wk49000900
3wk5300600900
3wk66000600
3wk7300300600
3Wk89000900
3Wk900900
1 Solution

Accepted Solutions
Highlighted
Master II
Master II

See the attached qvw.

View solution in original post

1 Reply
Highlighted
Master II
Master II

See the attached qvw.

View solution in original post