Qlik Community

Qlik Sense App Development

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

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
lichang422
Contributor

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

Tags (1)
1 Solution

Accepted Solutions
Highlighted
zhadrakas
Valued Contributor II

Re: How could i filter my data in table

maybe like this

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

View solution in original post

7 Replies
Highlighted
zhadrakas
Valued Contributor II

Re: How could i filter my data in table

maybe like this

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

View solution in original post

Highlighted
lichang422
Contributor

Re: How could i filter my data in table

Thank you for rapidly answer!

Highlighted
lichang422
Contributor

Re: How could i filter my data in table

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

How could i type ??

Highlighted
zhadrakas
Valued Contributor II

Re: How could i filter my data in table

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)

Highlighted
lichang422
Contributor

Re: How could i filter my data in table

It is so easy , i thinking too difficult ,

Thank you for your reply again.

Highlighted
lichang422
Contributor

Re: How could i filter my data in table

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

Can i not show it ??

未命名.jpg

Highlighted
lichang422
Contributor

Re: How could i filter my data in table

Oh, I got it ,

When I cancel the "include NULL value"

It will not show it.