https://community.qlik.com/t5/Insight-Advisor/Above-function-help-chart-function/m-p/2117629#M285 <P>Hello I am fairly new to qlik, so maybe there’s a way to do this which I don’t understand. I am using the Above() function nested in RangeSum() which essentially gives me the sum of an array. However, I would the 3rd parameter, count, to be dynamic - change accounting to the number of dates available for a particular year. Can someone please help me with this? Thanks</P> Sat, 16 Sep 2023 15:12:24 GMT satavkupa 2023-09-16T15:12:24Z https://community.qlik.com/t5/Insight-Advisor/Above-function-help-chart-function/m-p/2117629#M285 <P>Hello I am fairly new to qlik, so maybe there’s a way to do this which I don’t understand. I am using the Above() function nested in RangeSum() which essentially gives me the sum of an array. However, I would the 3rd parameter, count, to be dynamic - change accounting to the number of dates available for a particular year. Can someone please help me with this? Thanks</P> Sat, 16 Sep 2023 15:12:24 GMT https://community.qlik.com/t5/Insight-Advisor/Above-function-help-chart-function/m-p/2117629#M285 satavkupa 2023-09-16T15:12:24Z https://community.qlik.com/t5/Insight-Advisor/Above-function-help-chart-function/m-p/2122795#M293 <P>Hi&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/246694">@satavkupa</a>,&nbsp;could you upload an example of what you are looking for? Simulate it in a excel for example</P> Wed, 27 Sep 2023 06:09:45 GMT https://community.qlik.com/t5/Insight-Advisor/Above-function-help-chart-function/m-p/2122795#M293 Mario_De_Felipe 2023-09-27T06:09:45Z