Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
MCHK
Contributor II
Contributor II

Amending an expression to include all results that contain some text

I have an expression

Count({<Group_Class_Name = {'Pregnancy Essential'}>}groupDate)

How can I amend this so that it counts all Group_Class_Names that include the words 'Pregnancy Essential'   As we have different vesions 'Pregnancy Essential:2023, Pregnancy Essential:2024, Pregnancy Essential:Pre natal' etc.   I don't want to specify the exact name of each class as I would need to update the expression regularly as new classes are added.

Thank you!

 

 

 

Labels (1)
1 Solution

Accepted Solutions
jochem_zw
Partner Ambassador
Partner Ambassador

use double quotes and wildcard

Count({<Group_Class_Name = {"Pregnancy Essential*"}>}groupDate)

View solution in original post

3 Replies
jochem_zw
Partner Ambassador
Partner Ambassador

use double quotes and wildcard

Count({<Group_Class_Name = {"Pregnancy Essential*"}>}groupDate)

MCHK
Contributor II
Contributor II
Author

Thank you, that works. If I also wanted to use this query but to sum the Duration_Hours of those group_Class-Names that match and fall in the groupDate period being searched, how could I amend this?  I would then have the count of classes and also the total duration in hours of the classes that meet the criteria.


jochem_zw
Partner Ambassador
Partner Ambassador

Sum({<Group_Class_Name = {"Pregnancy Essential*"}>}Duration_Hours )???