Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Uploads getting stuck in the virus scanner. We are investigating.
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

How to calculate cumulative data in Qlik Sense?

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?


捕获.PNG


You could refer to raw data in attachment

Thank you for your advice in advance

Ivan

12 Replies
Highlighted

This?

Capture.PNG

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

View solution in original post

Highlighted
Contributor III
Contributor III

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

Highlighted