topic Another Query using Set Analysis in QlikView https://community.qlik.com/t5/QlikView/Another-Query-using-Set-Analysis/m-p/274596#M102644 <HTML><HEAD></HEAD><BODY><P>Hello Experts,</P><P></P><P>I have a YearMonth dimension which I use in a chart to calculate the count of loans which statis is Recovered and it works fine with the below expression.</P><P></P><P>count({$&lt;vLastFctBalanceExtended.LoanStatus ={'Recovered'}&gt;}distinct LoanKey)</P><P></P><P>But I want to check how many loans has converted to status Recovered in that YearMonth and not the total starting from Jan. </P><P></P><P>Can someone help me with this please</P><P></P><P>Thanks a Lot in advance,</P></BODY></HTML> Tue, 16 Aug 2011 09:50:00 GMT 2011-08-16T09:50:00Z Another Query using Set Analysis https://community.qlik.com/t5/QlikView/Another-Query-using-Set-Analysis/m-p/274596#M102644 <HTML><HEAD></HEAD><BODY><P>Hello Experts,</P><P></P><P>I have a YearMonth dimension which I use in a chart to calculate the count of loans which statis is Recovered and it works fine with the below expression.</P><P></P><P>count({$&lt;vLastFctBalanceExtended.LoanStatus ={'Recovered'}&gt;}distinct LoanKey)</P><P></P><P>But I want to check how many loans has converted to status Recovered in that YearMonth and not the total starting from Jan. </P><P></P><P>Can someone help me with this please</P><P></P><P>Thanks a Lot in advance,</P></BODY></HTML> Tue, 16 Aug 2011 09:50:00 GMT https://community.qlik.com/t5/QlikView/Another-Query-using-Set-Analysis/m-p/274596#M102644 2011-08-16T09:50:00Z