Skip to main content

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Skip the ticket, Chat with Qlik Support instead for instant assistance.
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.