Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
JoseGarcia
Creator III
Creator III

Table chart- Column text filter

Hi, 

I would like to filter a table column to only display data that starts with 'UK-Class'.

Using this formula, but I am missing the rest of the data string.
Could anyone help?

Formula:
If([EightD.Title]= 'UK - Class', [EightD.Title])

This an example: 

UK - Class- 345
UK - Class- 720
Nottingham incentro
Northern Line
(only want values that start with UK - Class)

Thanks a million.

Jose

Labels (2)
1 Solution

Accepted Solutions
Or
MVP
MVP

You could use WildMatch( [EightD.Title],'UK-Class*' )

 

View solution in original post

2 Replies
Or
MVP
MVP

You could use WildMatch( [EightD.Title],'UK-Class*' )

 

JoseGarcia
Creator III
Creator III
Author

Magic! 
@Or 

If(WildMatch( [EightD.Title],'UK - Class*' ),[EightD.Title])

Thanks  🙂