Discussion Board for collaboration related to Creating Analytics for QlikView.
I need no find a function to find the strings "AA12" and "BB12" in the middle of a large string.
And count how many AA12 and BB12 where found in a list of strings
Go to Solution.
Create a field in the script that gets the value 1 if there's a match:
if(wildmatch(MyString, '*AA12*','*BB12*'),1,0) as Flag
Then you can use an expression sum(Flag) in a textbox or chart to count these cases
If you just want to count how often AA12 occurs in MyString you can use substringcount(MyString,'AA12')