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.

[zar]

Did you considered just use filter pane for each or those 3 fields and have a KPI that Count (Distinct Field1&Field2&Field3) ?

[Thathayoyo · Accepted solution]

Thanks for you answer. I solved it by creating a key when i load my data in order to link two dataset. Then i dont need variable to make a selection and now it's work correctly.