This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
I am new to qlikview and I need a solution for searching a substring in each sentence.
For example I want to search for a word called DISK from the below sentences:
1. Disk was full.
2. Disk error.
3. Disk space error.
What function can be used to search.Please help.
You didn't say what you wanted to do if the word is found.
This will return the position of the word in the string:
You can try with Match, Mixmatch and Wildmatch.
You could take Mike Woolf's answer a bit further...
=If(Index(FieldWithSentence,'Disk') >0,'Found','Not Found');
If(sentence like '*Disk*', dosomething, dosomethingelse)
What I am trying to get is ,if i use inner join between two tables below
I am getting the output as
But my expected output is
The words with in the string also should match and give me the output
the output should be like below: