Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
R_Mitchell
Contributor
Contributor

2 Year Cumulative Line Chart Help

Hi there,

I have created a line chart comparing 2 years worth of sales data as below:

Qlik Pivot.JPG

I have the dimensions Week and Fiscal Year and the current measure "Sales (inc. VAT)". I want to be able to see the year sales cumulatively rather than week by week so I can see a continual upward chart. Any advise on what Expression I need to write?

Many thanks.

Rob

1 Reply
sunny_talwar

May be this

Aggr(
  RangeSum(Above(Sum([Sales (inc. VAT)]), 0, RowNo()))
, YearField, WeekField)