topic calculating last five weeks data in QlikView

calculating last five weeks data

srikanthphilips — Sat, 16 Nov 2024 04:46:06 GMT

Hi All,

Need help in the below scenario.

	Manual Invoices	Total Invoices	Avg of B/C
Week 52	10	20	0.5
Week 51	20	30	0.666666667
Week 50	30	40	0.75
Week 49	40	50	0.8
Week 48	50	60	0.833333333
Total	150	200	0.75

Average of Week 52 to Week 48 is 0.75 will be one bar in my bar chart.

I need to put it in graph chart.

So 4 weeks of avg data i am showing in the above.

The second bar should be from Week 49, Week 50, Week 51, Week 52 and week 1.

I have mentioned Week 1 because this is january 2019 and we are in 1st week.

please help.

Re: calculating last five weeks data

chrismarlow — Wed, 16 Jan 2019 11:05:51 GMT

Hi,

If you want to show a rolling average and its constituent parts in a bar chart (which might be what you are getting at …), if there are not many bars you can just use different expressions for each piece, similar to the below (I've stopped at the 3 bars as just an example);

There are things that can be done to improve the display (e.g. change bar colours, get text on the axis). The set analysis used to get the dates should also be dynamic, but getting into that really depends on your data model & if this is even what you are trying to do.

Cheers,

Chris.