How to exclude condition filtered value in Qlik Sense

[mvgadagi]

Hello All,

I am new to the Qlik Sense and struck in finding the solution for the below problem,

Problem Statement: Currently I have the input data as below and each record may contain multiple releases with comma separated. We wanted to generate the table with below condition

1. When the user opens the view all the records should be displayed
2. When the user clicks Select all in the filter pane and excludes anyone Category and If the RecordID contains that excluded Release it should not be shown in the Output Table

So When User

1. Selects All and exclude Release1 , The output table should have only RecordID 6,8,9,30,38
2. Selects All and exclude Release2, The output table should have only Record ID 8,9,25,38
3. Selects All and exclude Release1 and Release2 , The output table should have only Record ID 6,8,9,38

Input Data Table

RecordID	Category
2	Release1,Release2
6	Release2
8	Release3
9	Release4
25	Release1
30	Release2,Release5
38	Release6

Category Filter

Release1

Release2

Release3

Release4

Release5

Release6

Please find the attached qvf file for the project sample project setup

Before asking this question I have tried these below but still, we are not able to get the solution

• https://community.qlik.com/t5/New-to-Qlik-Sense/How-to-ignore-filter-in-a-table/td-p/32672
• https://community.qlik.com/thread/226410
• https://community.qlik.com/t5/QlikView-Scripting/quot-Reverse-quot-filter-list-box/m-p/1091988

Thanks,

[vikasmahajan]

Check Attached file,

Vikas

[mvgadagi]

Thanks for your quick answer,

But actually, I from the solution when I Select all and Exclude Release 2 , Still, I am seeing the Record ID 30 but I don't want to see this, as RecordID 30 is having Release2