Qlik Community

Qlik Sense App Development

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

deepanshu_chamo1
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!!

Thanks

Deepanshu

Tags (1)
2 Replies

Re: Search the names

May be this:

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

or

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