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
Hi, you could try adding a expression in the 3rd parameter, something like:
Count(Distinct dateField)
Essentially, this would count every distinct date present in your model, but respecting the user/year selection.
You could be more specific and add a set analysis to it, if you must look for specific dates, or even ignore the filters by adding {1} within the expression
