How to calculate cumulative data in Qlik Sense?

[ivanyang25]

Dear Qlik Sense Experts

I am new to Qlik Sense and I am a front end user

Now my raw data is as below. First line shows how many orders shipped in specific days

Take [E2] as an example, it means there are 4 orders take 6 days to ship from plant

Now I want to add 2nd line to calculate the cumulative orders which shipped within specific days

Take [F3] as an example, there are 26 orders ships within 7 days

These 26 orders include:

1 order takes 5 days to ship

4 orders take 6 days to ship

21 orders take 7 days to ship

So 26 [F3] = [B2]+[C2]+[D2]+[E2]+[F2]

May I  know what expression I should use in Qlik Sense to make this request happen?

You could refer to raw data in attachment

Thank you for your advice in advance

Ivan

[sunny_talwar · Accepted solution]

This?

Aggr(RangeSum(Above(Count([Order Line]), 0, RowNo())) / Count(TOTAL <[Sold to Country]> [Order Line]),[Sold to Country], ([OTS Days(CD)], (NUMERIC)))

[ivanyang25]

Dear Sunny

I am sorry for the late response

It works! Thank you so much for the patience and guidance.

One small question here, what is the function of (NUMERIC) in this expression?

Very appreciate your kindly help

Ivan

[sunny_talwar]

Read about this here:

The sortable Aggr function is finally here!