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

Announcements
Talend Cloud AWS EU Scheduled Outage: Starting Tues 26 May 21:00 CEST with expected completion Wed 27 May 01:00 CEST
cancel
Showing results for 
Search instead for 
Did you mean: 
manu1512
Creator
Creator

Cumulative sum

Hi all,

 

I am using rangesum for the counting the expression in trend chart.

 

rangesum(above(Sum({<Equipment_isSMA_Upgrade_Eligible={1},Flag={2},MonthYear=,QuarterYear=>}if(EquipmentStartYear<= Year,EquipmentCount)),0,RowNo())))

 

but when i am selecting any year the values are getting changed ....which is not required by business.

 

Can anyone help me in finding the alternate solution for this?

 

 

Labels (1)
11 Replies
manu1512
Creator
Creator
Author

sorry it does not make any difference but still many thanks for help

manu1512
Creator
Creator
Author

IT WORKED Many thanks .......just need to remove flag =2 in average expression