
Partner - Contributor
2023-10-20
07:56 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Checking for Integer
Hi community, I am still new to Qlik. How do i check to see if the first character is an integer. e.g. I have a product ID 1234BE3
Thanks.
AP
544 Views
1 Solution
Accepted Solutions


Creator II
2023-10-20
10:03 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Isnum(left('1234BE3',1)), results - Numeric value "-1" and non-numeric value "0".
516 Views
2 Replies

Specialist II
2023-10-20
09:50 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi, @ProfPhidd
Leave a suggestion
There may be other better solutions, this is a path I found.
see if it helps
flag
if(Left(field,'1') >=0
and
Left(field,'1') <=9,
'int','not int')
Did you find a solution to your question? Mark the solution as accepted ✅ and if you found it useful, press the like button!
522 Views


Creator II
2023-10-20
10:03 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Isnum(left('1234BE3',1)), results - Numeric value "-1" and non-numeric value "0".
517 Views
