Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Data Checking

Hi All,

Is it possible to check the below condition in Qlikview Script level.

Ex: I have an data like Below

 

AU WACUA TP
SQ-793578/3791862/3760163/3760248/3685781/3614436/reb/T1/EG/DATA#3
SQ-
Vol-Dir\Hp BLc VC\DEPT OF Defence
SQ- 3795145/3750960/3725862/ SQ-3644201/3566197

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

2 Replies
Specialist III
Specialist III

How about the below:

Capture.PNG

This assumes that there is no additional space between 'SQ-' and the starting number.

Hope this helps.

Highlighted

‌If(field like 'SQ-*' and IsNum(Mid(field,4,1)), true, false)

regards

Marco