Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
lichang422
Creator
Creator

How could i filter my data in table

i had a lot kind of data.

But i just only want to show some data in table likes all of bat data

How could i type in expression??

未命名.jpg

Labels (1)
1 Solution

Accepted Solutions
zhadrakas
Specialist II
Specialist II

maybe like this

if(WildMatch(SimpleSignalName, '*Bat*'),SimpleSignalName)

View solution in original post

7 Replies
zhadrakas
Specialist II
Specialist II

maybe like this

if(WildMatch(SimpleSignalName, '*Bat*'),SimpleSignalName)

lichang422
Creator
Creator
Author

Thank you for rapidly answer!

lichang422
Creator
Creator
Author

If I also want to filter FAN data(Bat and FAN),

How could i type ??

zhadrakas
Specialist II
Specialist II

just add another search string

if(WildMatch(SimpleSignalName, '*Bat*', '*FAN*'),SimpleSignalName)

i dont know if that works as expected. you could also try

if(WildMatch(SimpleSignalName, '*Bat*', '*FAN*')>=1,SimpleSignalName)

lichang422
Creator
Creator
Author

It is so easy , i thinking too difficult ,

Thank you for your reply again.

lichang422
Creator
Creator
Author

Why when i used filter in expression, I also can see some data is hidden(gray color )

Can i not show it ??

未命名.jpg

lichang422
Creator
Creator
Author

Oh, I got it ,

When I cancel the "include NULL value"

It will not show it.