Qlik Community

Qlik Sense App Development

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

New Contributor

Search the names

Hello All

Please help in the below query in Qlik Sense

I have a list of 1000 rows. In some rows the name "deep" & "ravi" is present.

Can anyone tell me how to count the rows which contains "deep" & "ravi"

Please help!!



Tags (1)
2 Replies

Re: Search the names

May be this:

Count({<name = {'*deep*'}*{'*ravi*'}>}name)


Count({<name = {'*deep*'}>*<name = {'*ravi*'}>}name)

Sample attached

Re: Search the names

if you want to count deep or ravi, then you can try this:

Count({<name = {'*deep*', '*ravi*'}>}name)

Community Browser