Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
stekol61
Contributor

count and wildcard

I have a table in Sense as  below.

How can I count  'Closed' and 'Cleared' in 'Org_status'  (the result should be '3')?

Count.PNG

1 Solution

Accepted Solutions

Re: count and wildcard

Try this

Count({<[Org Status] = {'Closed', 'Cleared'}>} DISTINCT [Ticket ID])

View solution in original post

1 Reply

Re: count and wildcard

Try this

Count({<[Org Status] = {'Closed', 'Cleared'}>} DISTINCT [Ticket ID])

View solution in original post