Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
This?
Aggr(RangeSum(Above(Count([Order Line]), 0, RowNo())) / Count(TOTAL <[Sold to Country]> [Order Line]),[Sold to Country], ([OTS Days(CD)], (NUMERIC)))
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
Read about this here: