Discussion Board for collaboration on QlikView Scripting.
Hi, I would like to count the appearance of a word in a List of Sentences.
1 Hello World
3 the force awakens
4 the force may be with you
5 The Storm
Now I want to count for example “force” or “the”.
Force should be (2) and the (3)
I have tried
Go to Solution.
If words can begin with a capital letter, use, for example, function lower()
Try with wildcard search, like: