Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Bethany
Contributor II
Contributor II

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?

1 Solution

Accepted Solutions
Kushal_Chawda

@Bethany  may be below

Count({<[Course Status]={'Completed'}, Course_Name={'Specify Course Name'}>}[Region])

View solution in original post

2 Replies
Kushal_Chawda

@Bethany  may be below

Count({<[Course Status]={'Completed'}, Course_Name={'Specify Course Name'}>}[Region])

View solution in original post

Bethany
Contributor II
Contributor II
Author

Hi Kush, this worked perfectly. Thank you!