
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Count with two conditions
Hi All,
I'm trying to produce a dashboard in Qlik Sense using data from an Excel workbook which details several different courses of learning material and lists which members of staff (across several different business areas) who have or haven't completed them.
I've previously used the following expression to count how many people across various Regions (teams) of the business have completed the course in cases where the spreadsheet only refers to one module of work:
Count({<[Course Status]={'Completed'}>}[Region])
Now that I'm working from a spreadsheet that lists several different courses, can anyone help me to figure out how to specify in the expression that I only want to count results for one of the courses listed?
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@Bethany may be below
Count({<[Course Status]={'Completed'}, Course_Name={'Specify Course Name'}>}[Region])

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@Bethany may be below
Count({<[Course Status]={'Completed'}, Course_Name={'Specify Course Name'}>}[Region])

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Kush, this worked perfectly. Thank you!
