Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
thomas_skariah
Creator III
Creator 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
Creator III
Creator III
Author

untitled.JPG

Here i need average of previous quater before week 26.

Any idea?

Regards,

Tom

Not applicable

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