topic Re: Search the names in App Development

Search the names

Anonymous — Thu, 17 Mar 2016 17:46:01 GMT

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

sunny_talwar — Thu, 17 Mar 2016 17:47:44 GMT

May be this:

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

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

Sample attached

sunny_talwar — Thu, 17 Mar 2016 17:51:05 GMT

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

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