Search the names

[Anonymous]

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]

May be this:

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

or

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

Sample attached

[sunny_talwar]

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

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