Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Rafal42
Contributor
Contributor

Using A Filter Expression In A Calculated Condition To Be Able To Select More Than 1 Value

Hello,

I am stuck on a relatively simple problem, seemingly. I currently have a course filter in a Qlik Sense app that only provides certain courses on a particular sheet. That expression looks like this...

=IF(MATCH(COURSE_TITLE, $(vSalesCourse), $(vCommercialCourse)), COURSE_TITLE)

This works perfectly fine. The issue is that I have too much data coming into the table in the sheet when first opening it. The solution is to put a calculated condition in that table. The problem is that I can only select one course from the filter to view data in the table. I can't select 2, 3, or more courses in the filter to see more data in the table. Below is the calculated expression I am using. Any help would be appreciated.

IF(COURSE_TITLE = IF(MATCH(COURSE_TITLE, $(vSalesCourse), $(vCommercialCourse)), COURSE_TITLE), 1, 0)

 

Labels (7)
0 Replies