Discussion Board for collaboration related to QlikView App Development.
Is it possible to check the below condition in Qlikview Script level.
Ex: I have an data like Below
Now i want to check if my field value starts with SQ-[0-9] ([0-9] is the number range) then condition True else False
Please help on this
How about the below:
This assumes that there is no additional space between 'SQ-' and the starting number.
Hope this helps.
If(field like 'SQ-*' and IsNum(Mid(field,4,1)), true, false)