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
Can you provide more details about your question? What is your current formula, how does your data look llike? What are you trying to achieve?
It sounds like you are trying to calculate the YTD cumulative total - maybe there is an easier way to calculate it, other than using RANGESUM(Above()) ?
To learn more advanced development techniques, check out the agenda of the Masters Summit for Qlik - coming soon to Orlando and to Dublin!
