Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
JoseGarcia
Creator III
Creator III

Cumulative trend line chart

Hi there, 

Hope you are well. 

Trying to make a cumulative Trend line chart.
Using Formula:

=
RangeSum(Above(ImpactValue, 0, RowNo())MonthUpdate))

But not adding values?

can anyone assist?

Thanks a million.

 

Jose

 

 

Labels (2)
1 Solution

Accepted Solutions
Taoufiq_Zarra

Maye be :

in measure

aggr(rangesum( above( sum(ImpactValue),0,rowno())),MonthUpdate)

 

and MonthUpdate as dimension

 

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉

View solution in original post

2 Replies
Taoufiq_Zarra

Maye be :

in measure

aggr(rangesum( above( sum(ImpactValue),0,rowno())),MonthUpdate)

 

and MonthUpdate as dimension

 

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
JoseGarcia
Creator III
Creator III
Author

It worked! 

Thanks  a million 

Jose