Discussion Board for collaboration related to Creating Analytics for QlikView.
In a field I have a string of numbers like this:
Is there an expression that can help me to find that in this row the number 1 is on 2nd, 3rd etc place in this string?
Thank you for your help!
You can try using the mid function. To check if the second character is a 1: if(mid(MyString, 2,1)='1', 'Match', 'No Match')
Or to check three 1's starting from position two: if(mid(MyString, 2,3)='111', 'Match', 'No Match')
View solution in original post
Thank you! Works great!