Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Thathayoyo
Contributor III
Contributor III

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

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.

Thathayoyo_0-1728576304640.png

Thanks.

 

Labels (4)
1 Solution

Accepted Solutions
Thathayoyo
Contributor III
Contributor III
Author

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.

View solution in original post

2 Replies
zar
Employee
Employee

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

Thathayoyo
Contributor III
Contributor III
Author

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.