https://community.qlik.com/t5/Catalog-and-Lineage/Above-function-help-chart-function/m-p/2422873#M1254 <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> Fri, 23 Feb 2024 11:39:39 GMT hamish2 2024-02-23T11:39:39Z https://community.qlik.com/t5/Catalog-and-Lineage/Above-function-help-chart-function/m-p/2422873#M1254 <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> Fri, 23 Feb 2024 11:39:39 GMT https://community.qlik.com/t5/Catalog-and-Lineage/Above-function-help-chart-function/m-p/2422873#M1254 hamish2 2024-02-23T11:39:39Z https://community.qlik.com/t5/Catalog-and-Lineage/Above-function-help-chart-function/m-p/2422906#M1255 <P>above(sum(Sales),1,<SPAN>round(YearEnd(Today())-YearStart(Today())))</SPAN></P> Fri, 23 Feb 2024 12:40:25 GMT https://community.qlik.com/t5/Catalog-and-Lineage/Above-function-help-chart-function/m-p/2422906#M1255 anat 2024-02-23T12:40:25Z https://community.qlik.com/t5/Catalog-and-Lineage/Above-function-help-chart-function/m-p/2422909#M1256 <P>You should be able to use an expression instead of an explicit number, something like:</P> <P>above(sum(x), 0, <EM>GetPossibleCount(datedimensionname)</EM>)</P> Fri, 23 Feb 2024 12:45:44 GMT https://community.qlik.com/t5/Catalog-and-Lineage/Above-function-help-chart-function/m-p/2422909#M1256 henrikalmen 2024-02-23T12:45:44Z