Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
@Bethany may be below
Count({<[Course Status]={'Completed'}, Course_Name={'Specify Course Name'}>}[Region])
@Bethany may be below
Count({<[Course Status]={'Completed'}, Course_Name={'Specify Course Name'}>}[Region])
Hi Kush, this worked perfectly. Thank you!