Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Ahmed_Shenawy
Contributor
Contributor

Visualization filter for 1 column but has expression to filter out specific value for another column

im trying to add a visualization filter box with dimension of 1 column, this is pretty straight forward as the expression for it is "=column_name". but also i want to return only the values that are linked to a specific selection from another column. example query below 

 

SELECT [column_name]

WHERE [Another_column] NOT LIKE '%random%'

 

Labels (3)
1 Solution

Accepted Solutions
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

If you can get by with using "*" wildcard instead of "%", you can write it like this:

=Aggr(Only({<[Another_column]= -{"*random*"}>}[column_name]), [column_name])

% is documented as being valid here, but does not work. I think it's a bug.  If you have to use "%", I'm sure there's a workaround

 

-Rob

View solution in original post

1 Reply
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

If you can get by with using "*" wildcard instead of "%", you can write it like this:

=Aggr(Only({<[Another_column]= -{"*random*"}>}[column_name]), [column_name])

% is documented as being valid here, but does not work. I think it's a bug.  If you have to use "%", I'm sure there's a workaround

 

-Rob