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

[#1]

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,

[#2 · Accepted solution]

Use IsNum()/IsText() functions

[Alejandro_Hernández]

with isnum(). for example:

load Value, isnum(Value) as IsNum inline [

Value

1

2

a

b

4

w

?

]

[hic]

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