topic IsNum()???? in QlikView

IsNum()????

Tue, 05 Jan 2010 19:08:27 GMT

Hi,

Why does the IsNum() logical function see 'R54305' and '3E12' as Numbers? Or at least returns 'true' for these values?

Is it seeing the first one as a currency value perhaps? And the second one as coordinates?

Please help, this is screwing me around... [:@]

Thanx!

Hesten-

IsNum()????

hector — Tue, 05 Jan 2010 19:44:28 GMT

Hi, well 3e12 it's been read as 3.000.000.000.000, you can check this doing a textbox with this expression num('3E12','#.##0').

the other value, at least for me xD, isn't a number, maybe you can do the same test that i mentioned above, num('R54305','#.##0').... this returns me a null (-) value

rgds

IsNum()????

Tue, 05 Jan 2010 20:06:20 GMT

Thanks!!!

I just wish I knew why it still sees the other value as a number... oh well...

IsNum()????

Wed, 06 Jan 2010 01:04:11 GMT

I just tried this in 9, and isnum('R54305') returns 0.

IsNum()????

Oleg_Troyansky — Wed, 06 Jan 2010 07:33:01 GMT

Hesten,

it's called "scientific notation":

nnnEmmm = nnn * 10 ^ mmm

(where sign ^ means "10 to the power of mmm")

It's used in some scientific applications to represent exceptionally large or exceptionally small numbers.

cheers,

IsNum()????

Wed, 06 Jan 2010 08:48:28 GMT

Thanks guys.

I also used it on its own and got 0 for isnum(R54305). But somehow, when reading it from source files and being part of other functions, it still saw it as a number and I got -1. But I have found a way around this for my specific solution, so don't worry. Seeing as no one else could reproduce it... I guess we'll leave it there.

Thanks Oleg... these are the kinds of things one forgets while struggling... I got so caught up in the issue that I didn't even think of that...

Thanks.