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
Hello, Above() is used in chart to operate with the rows of data above. In wich kind of chart do you want to use this? what are the dimesnions and the values?
In example if a year has 365 days and its add the 364 rows above, I'm not sure if you want to do this for all the data rows, maybe in a chart with date as dimension and you want to add all days, but this will only makes sense on the last day of the year, the other dates shouldn't go 364 days above or they will add data from past years.
I think it will be better if you add some sample data and the result you want to get.
BTW, you can just use Rangesum(Above([Expression],0,RowNo(TOTAL))) to accumulates all rows on a table.
