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: 
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 (1)
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