I have a general set analysis question. Not sure how to do it, the below expression gives me the count correct for a CalendarMonth, where the status of the loan is Recovered. But I want to know how to count the ones which are recovered in a particular month.
count({$<vLastFctBalanceExtended.LoanStatus ={'Recovered'}>}distinct LoanKey) // This is giving me the total of loans which are Recovered status and that keeps adding up for months. But I want to check only the number of loans which changed to recovered in a particular CalendarMonth.
I feel like I have already done this, but just stuck here and need some push.
Please attach a sample QVW, since it is tricky to give a goos suggestion without seeing your datat model and the object where you are applying the expression.
So, in your case, instead of checking the Status="Recovered", you should be checking the Month when the Status become "Recovered". If you don't already have a filed for the status change date or month, you need ot calculate it, preferably in the load script. I'm assuming you shoudl have monthly snapshots of loan statuses, and one month the status changes to "Recovered". You need to capture that moment and save the month in a separate field that can be then used in Set Analysis.
