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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Filter Rows by Substring

I want to filter out rows if "total" or "sub total" is found in the test from a particular column.
Since this is a substring I am looking for I wasn't sure what the best approach was.
Thanks,
Labels (2)
2 Replies
alevy
Specialist
Specialist

Use tFilterRow with an advanced condition like:
input_row.columnName.contains("total")
Anonymous
Not applicable
Author

Use tFilterRow with an advanced condition like:
input_row.columnName.contains("total")

Thanks Alevy. I stumbled across it (had to scroll in the panel to see it) and got it to works.
Thanks Again!