Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be this:
Count({<name = {'*deep*'}*{'*ravi*'}>}name)
or
Count({<name = {'*deep*'}>*<name = {'*ravi*'}>}name)
Sample attached
if you want to count deep or ravi, then you can try this:
Count({<name = {'*deep*', '*ravi*'}>}name)