Cumulative chart

[Fiorrie]

Hi Team

I would like to create dynamic cumulative chart which has revenue split per weeks. Right now, we are in week 1, from tomorrow, we will be in week 2, the cycle continues as this, every Tuesday new week enters (so it should be adding dynamically). I would like to show only those weeks which are active (however on x axis I still want to see weeks 1-13, just not displaying revenue which should not be there), right now it is showing me the same revenue from week 1 across all 13 weeks (i would like to neglect that revenue). I have variable telling me the current week number, but somehow it does not work.

Many thanks in advance

[dplr-rn]

assuming your individual expression is Sum(LineSalesAmount)

use below

rangesum(above(Sum(LineSalesAmount),0,RowNo()))

[Fiorrie]

Hi Dilip

This is helping except all other weeks disappear. I am using currently this, because I also want it to be stable for current quarter.

RangeSum(Above(Sum({$<[qtr_flag]={0},qtr=>}revenue),0,RowNo()))

With your expression I am getting this.

rangesum(above(Sum(revenue),0,RowNo()))

What I want to achieve is this (I have there also YoY trendline, so once I do not have new week, the trendline should be zero).

Excel example

Thanks!

[juraj_misina]

Can you post your expression here?

Optionally (assuming from your name), we can move this discussion to Qlik komunita - CZ &amp; SK‌ and continue in Slovak/Czech language if that helps.

Juraj