Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
PS - I am trying to solve for a Year To Date calculation, but I think this is what I need to fix. Let me know if this makes sense. Thanks
Hi Keron,
Try something like :
Rangesum(above(total Measure), 0, $(=Count({<Date={">=$(=date(yearstart(max(Date),0,4))) <=$(=Date(max(Date)))"}>}distinct Date)))
Let me know if it worked out for you.
Regards,
Rohan.