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: 
Not applicable

1 chart, 2 expressions, 2 dimension

Hi All!

A client ask for the next things...

I have a bar/line chart with a dimension of year_week (2010-1, 2010-2, etc).

1 line expression is quite simple.

The other one has to do the following:

Show acumulated sales by year in the current/selected week.

If we are in the 11 week of the year, I need for every year a bar in week 11 with the YTD sales.

I found a workaround using 2 graphs (and making the front transparent) and with an auxiliar table for the weeks acumulation

2010-1   2010-1

2010-2   2010-1

2010-2   2010-2

...

Does anyone imagine a solution but in only 1 chart?

Regards

Federico

1 Solution

Accepted Solutions
Not applicable
Author

Rangesum(Above(sum(sales),0,Week))

This should accumulate the number of the current week back

IE if week is 11 it would sum the sales for the past 11 weeks

View solution in original post

1 Reply
Not applicable
Author

Rangesum(Above(sum(sales),0,Week))

This should accumulate the number of the current week back

IE if week is 11 it would sum the sales for the past 11 weeks