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

Announcements
Note: You may notice some temporary visual or styling issues in the Community. Our vendor is actively investigating.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Cumulative average Month by month

Hi community.


I am trying to generate an accumulated average month by month.


This way it works:
Captura.PNG


But I need to show the data in this visualization, but the result is different

Captura2.PNG

This is the expression that I am using:


RangeSum(above(sum(CustomerSpend),0,rowno()))/RangeSum(above(sum([Customer Count]),0,rowno()))


I try to show the same information in both graphs, but when changing the type of table it is calculated different.



1 Reply
petter
Partner - Champion III
Partner - Champion III

Above() might have to change to Before()....