Expression editor : Filtering Qliksense Table with specific triplet variables combination across multiple columns

[Thathayoyo]

Hello,

I am working on the expression editor where i have 3 columns on a table each i want to filter by a separate variable (list of string like:  AZ104;ERF21 ). For the moment i have that:

=Count(If(SubStringCount(';' & VarA & ';',';' & [TABLE.ColumnA] & ';') > 0 AND

SubStringCount(';' & VarB & ';',';' & [TABLE.ColumnB] & ';') > 0 AND

SubStringCount(';' & VarC & ';',';' & [TABLE.ColumnC] & ';') > 0 , [[TABLE.ColumnA]))

The problem is if i apply this, it will try all the possible combination of values inside variables.  The goal is to filter the table by a specific triplets (all the values ​​indexed 1 of each variables as a triplet, all the values ​​indexed 2 of each variables as a triplet....etc). Here an exemple of what it my return (in yellow) , so here the Count() need to be 2.

Thanks.