Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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