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

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
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