Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
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

Tags (1)
2 Replies
Highlighted
Specialist III
Specialist III

Re: Data Checking

How about the below:

Capture.PNG

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

Hope this helps.

Highlighted

Re: Data Checking

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

regards

Marco