Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

General Set Analysis query...

Hello Experts,

The below expression gets me the count of Loans which are Recovered on any date for CalendarMonth, but what if I want to see only the ones which are Recovered in a particular CalendarMonth??

count({$<vLastFctBalanceExtended.LoanStatus ={'Recovered'}>}distinct LoanKey) // This gives me the total count starting from Jan.

I want to write something which shows me how many loans are Recovered in a CalendarMonth and not as on Month.

Thanks in Advance,

Feel like I did this before but not sure.

Mady

0 Replies