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

Problem with accumulation

I have the following table

day     monthyear     total     accum     dailyAvg

1          may12          271     271          ??

2          may12          311     582

3          may12          328     910

4          may12          338     1248

5          may12          309     1557

6          may12          295     1852

7          may12          341     2193

8          may12          333     2526

....

31        may12          332     9953

1          jun12            345     345

2          jun12            310     655  

...

i performed the expression "accum" by copying the TOTAL column and activating the switch "full Accumulation", then I tried to make a daily average and for it i created the term "dayavg" as "accum / day" but the result I get is like "TOTAL / day", any ideas?

Thanks in advance

1 Solution

Accepted Solutions
fernando_tonial
Employee
Employee

Hi,

You can see my example.

I hope this helps.

Don't Worry, be Qlik.

View solution in original post

2 Replies
fernando_tonial
Employee
Employee

Hi,

You can see my example.

I hope this helps.

Don't Worry, be Qlik.
Not applicable
Author

Fernando...that's exactly what I needed!!! Thank you!