I'm having trouble coming up with the necessary code needed for a KPI chart. I currently have two working Master Items that I'm using in a simple table - a dimension for Year Months in the max available year and a measure for number of accounts opened each Year Month. Here's the code for each.
=count(if([OP Account Open Date] >= [First Of Month], [OP Account ID]))
And here's an example of the results in the table
I'd like a single measure that combines the logic from my two master items and properly aggregates to the total for all months (circled in the image). I also need it to filter properly when a user chooses specific years and/or one or more Year Month values from a filter pane.
My thought is that the aggr() function may come in handy here? I'm still a bit new to Qlik and that function's logic though, so I'm not sure.