Discussion board where members can get started with QlikView.
Can any one give an idea in which i have a weekly sales bar chart,what i need is to display avg of previous quarter before the first week in the bar chart.
In image i need avg of previous quarter before week 26.
Here i need average of previous quater before week 26.
Hi hope this help. NOte that in the example I use to variables "vCurrentWeek" and "vWeekPreviousQuarter". They come from the script
LET vCurrentWeek = Week(Today());LEt vWeekPreviousQuarter = vCurrentWeek-16;
LET vCurrentWeek = Week(Today());
LEt vWeekPreviousQuarter = vCurrentWeek-16;
I assume that when you talk about "Previous Quarter" you mean 16 weeks before and not the "natural quarter" : Jan-Mar, Ap-Jun,...
See the file attached