Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Can you determine whether a field is numeric or not in QlikView?

Hi,

I have a field, and it should just contain numbers - however due to the data structure it possible that the field contains text. If so, I want to be able to mark and/or filter these rows.

Regards,

1 Solution

Accepted Solutions
Not applicable

Re: Can you determine whether a field is numeric or not in QlikView?

Use IsNum()/IsText() functions

3 Replies
Not applicable

Re: Can you determine whether a field is numeric or not in QlikView?

Use IsNum()/IsText() functions

Employee
Employee

Re: Can you determine whether a field is numeric or not in QlikView?

with isnum(). for example:

load Value, isnum(Value) as IsNum inline [

Value

1

2

a

b

4

w

?

]

Employee
Employee

Re: Can you determine whether a field is numeric or not in QlikView?

Just as amit ray and Alejandro Hernandez suggest, you can use IsNum().

However, if you have texts like '3E4', these will be marked as TRUE by IsNum(), since it is a correct scientific numeric format. If you have such texts, it may be better to use

     Len(Purgechar(Value, '0123456789.'))=0

as test.

HIC

Community Browser