https://community.qlik.com/t5/App-Development/count-and-wildcard/m-p/1531533#M38263 <P>I have a table in Sense as&nbsp; below.</P><P>How can I count&nbsp; 'Closed' and 'Cleared' in 'Org_status'&nbsp; (the result should be '3')?</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Count.PNG" style="width: 292px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/3943iAE11DFC941AB3313/image-dimensions/292x188?v=v2" width="292" height="188" role="button" title="Count.PNG" alt="Count.PNG" /></span></P> Thu, 17 Jan 2019 12:34:53 GMT stekol61 2019-01-17T12:34:53Z https://community.qlik.com/t5/App-Development/count-and-wildcard/m-p/1531533#M38263 <P>I have a table in Sense as&nbsp; below.</P><P>How can I count&nbsp; 'Closed' and 'Cleared' in 'Org_status'&nbsp; (the result should be '3')?</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Count.PNG" style="width: 292px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/3943iAE11DFC941AB3313/image-dimensions/292x188?v=v2" width="292" height="188" role="button" title="Count.PNG" alt="Count.PNG" /></span></P> Thu, 17 Jan 2019 12:34:53 GMT https://community.qlik.com/t5/App-Development/count-and-wildcard/m-p/1531533#M38263 stekol61 2019-01-17T12:34:53Z https://community.qlik.com/t5/App-Development/count-and-wildcard/m-p/1531552#M38265 <P>Try this</P><PRE>Count({&lt;[Org Status] = {'Closed', 'Cleared'}&gt;} DISTINCT [Ticket ID])</PRE> Thu, 17 Jan 2019 13:02:00 GMT https://community.qlik.com/t5/App-Development/count-and-wildcard/m-p/1531552#M38265 sunny_talwar 2019-01-17T13:02:00Z