topic Check whether the value is number or not in QlikView

Check whether the value is number or not

Mon, 14 Apr 2014 12:56:11 GMT

Hi everyone,

I load some large Excel documents with numeric value and then show them in table chart.

I would like to make control on load to check if somebody enter letter in Excel document.

It would be the best If I could show that field in some table to know what I should rewrite.

Any help is welcome.

Tnx

alexandros17 — Mon, 14 Apr 2014 13:03:26 GMT

There are some functions thata test if a value is Numerical or is Null

Isnum(Value)

IsNull(Value)

when you load your data you can set flags something like

Load

...

if(isnum(myField), myField, 'X') as myFieldFlag

...

in this way all values having 'X' will contains wrong values

Mon, 14 Apr 2014 13:10:40 GMT

Tnx for reply,

I will check now

SlimJim — Wed, 27 Mar 2019 11:09:06 GMT

Simple IsNum may not always work. Try this also:

isnum( Num# (Field) )