topic How to use wildcard in set analysis in QlikView https://community.qlik.com/t5/QlikView/How-to-use-wildcard-in-set-analysis/m-p/327604#M1193656 <HTML><HEAD></HEAD><BODY><P>I have to count the values which has term 'Rejected' in the field. How do i do it with set analysis. below expression do not work</P><P></P><P><IMG src="https://community.qlik.com/" /></P><P></P><P>count({&lt;Invoice_Status&nbsp; = {'%Rejected%'}&gt;}Invoice_Status)</P></BODY></HTML> Tue, 28 Jun 2011 15:24:20 GMT 2011-06-28T15:24:20Z How to use wildcard in set analysis https://community.qlik.com/t5/QlikView/How-to-use-wildcard-in-set-analysis/m-p/327604#M1193656 <HTML><HEAD></HEAD><BODY><P>I have to count the values which has term 'Rejected' in the field. How do i do it with set analysis. below expression do not work</P><P></P><P><IMG src="https://community.qlik.com/" /></P><P></P><P>count({&lt;Invoice_Status&nbsp; = {'%Rejected%'}&gt;}Invoice_Status)</P></BODY></HTML> Tue, 28 Jun 2011 15:24:20 GMT https://community.qlik.com/t5/QlikView/How-to-use-wildcard-in-set-analysis/m-p/327604#M1193656 2011-06-28T15:24:20Z How to use wildcard in set analysis https://community.qlik.com/t5/QlikView/How-to-use-wildcard-in-set-analysis/m-p/327605#M1193657 <HTML><HEAD></HEAD><BODY><P> Try asterisks (*) instead of percents</P></BODY></HTML> Tue, 28 Jun 2011 15:29:26 GMT https://community.qlik.com/t5/QlikView/How-to-use-wildcard-in-set-analysis/m-p/327605#M1193657 m_woolf 2011-06-28T15:29:26Z