HELP with creating a graph

Thu, 02 Oct 2014 21:24:45 GMT

Can anyone help with this??? The requirement is to be able to see 5 weeks of historical forecast from current week and 10 weeks of future forecast from current week. As well as 5 weeks of actual from current week.

If current week = 9/1/2014

I will need historical forecast for weeks: 8/25, 8/18, 8/11, 8/4, 7/28

I will need actual sales for weeks: 8/25, 8/18, 8/11, 8/4, 7/28

I want to see future forecast for current week: 9/1 and 9/8, 9/15, 9/22, 9/29, so forth until 11/10

See attachment!

Re: HELP with creating a graph

bgerchikov — Fri, 03 Oct 2014 02:59:19 GMT

Please review attachment.

I showed you how to handle sales. Same way you can do forecasts. Just set up variables in the way you need in AddMonths function or use anything instead, like counters for the week.

Good luck!

topic Re: HELP with creating a graph in QlikView

HELP with creating a graph

Re: HELP with creating a graph