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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Expressions: full accumulation

Good morning,

I have a doubt in one expression. I have a  temporary line chart with weeks in the axe.

With one expresión, sum(Passengers) the full accumulation Works. But if i want to do something like " Revenue/ Passengers" it does not work, because is adding every week the "Rvenue per passenger and not reflecting the cummulate revenue / passenger till this date.

For example:

   

DatePASSENGERPassenger full acumREVENUEREVENUE Full accummRevenue / Passenger No
  accumulation
revenue/passenger Full
  accumulation
revenue/passenger what i want
20/06/201412312316.163,216.163,2131,6131,6131,56
27/06/201412725016.264,632.427,7128,3259,9129,92
04/07/201412137116.365,648.793,3135,0394,9131,57
11/07/201413050116.471,465.264,7126,4521,2130,22
18/07/201413063116.577,581.842,2127,4648,7129,65
25/07/201413176216.683,398.525,5127,8776,5129,33
01/08/201412088216.783,6115.309,1139,8916,2130,75
08/08/201411199316.882,0132.191,2152,31.068,5133,15
15/08/2014102109516.974,6149.165,8165,81.234,3136,20
22/08/201494118917.060,5166.226,3181,21.415,5139,77
29/08/201496128517.142,4183.368,7179,51.595,0142,72
05/09/201494137917.218,6200.587,3182,51.777,5145,44
------------WRONGRIGHT

Can someone helpme with this?

Thanks a lot!

BElén

0 Replies