Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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()....