Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Search in data

Hi guys,

I have a few rows of in the database that are comments made by users about handphone brands. The datafield is `comments`. These are just 2 examples,

'Overall, I prefer the iPhone 5s'

'I definitely prefer the Samsung'

I would like to filter the string and count them in terms of how many times the iPhone and Samsung was mentioned.

Thanks,

Nat

1 Reply
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

count({<comments={'*iPhone*','*Samsung*'}>}comments)


talk is cheap, supply exceeds demand