Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
thomas_skariah
Contributor III

Bar Chart

Hi All,

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.

Regards,

tom

2 Replies
thomas_skariah
Contributor III

Re: Bar Chart

untitled.JPG

Here i need average of previous quater before week 26.

Any idea?

Regards,

Tom

Not applicable

Re: Bar Chart

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;

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

Community Browser