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: 
Teppo_Ojala
Former Employee
Former Employee

Weekly average and daily sales in same combo chart

Hi,

Is there a way to build an expression that would calculate for example WEEKLY AVG SALES into same chart that is showing DAILY SALES.

Below is an image about the chart I am trying to build. Blue bars are SALES PER DAY and it has been built by normal SUM(SALES) expression. The pink lines has been added to picture in powerpoint, the idea is to show the weekly average in the same chart. The chart would show the weekly progress and daily numbers in one view. I just cant write a formula that will give me these lines.

 

 

Chart Image.png This graph has been build on top of dummy data-model that has one table, loaded by this inline script:

 

data:
load *, WeekDay & ' (Week: '&Week&')' as Weekday_Week;
load * Inline
[
Week, WeekDay, Sales
1, Mo, 100
1, Tu, 120
1, We, 130
1, Th, 120
1, Fr, 100
1, Sa, 120
1, Su, 130
2, Mo, 200
2, Tu, 220
2, We, 230
2, Th, 220
2, Fr, 200
2, Sa, 220
2, Su, 230
3, Mo, 300
3, Tu, 320
3, We, 330
3, Th, 320
3, Fr, 300
3, Sa, 320
3, Su, 330
];

Labels (1)
1 Solution

Accepted Solutions
sunny_talwar

Would something like this work?

image.png

View solution in original post

2 Replies
sunny_talwar

Would something like this work?

image.png

Teppo_Ojala
Former Employee
Former Employee
Author

Thanks for a quick reply. Yes, this is exactly what I wanted to see 🙂