topic ISNUM in script returns FALSE while on the GUI, it's TRUE? in QlikView

ISNUM in script returns FALSE while on the GUI, it's TRUE?

datanibbler — Thu, 16 Jul 2015 09:36:00 GMT

Hi,

I have a line like this in my script

>> LET v_Trace = IF(ISNUM([field]) = -1, 'yes', 'no') <<

Strangely, this returns "no" in the script while on the GUI the same function, applied at the same stage of execution, returns 'yes'.

Can somebody explain this difference to me?

Thanks a lot!

Best regards,

DataNibbler

Re: ISNUM in script returns FALSE while on the GUI, it's TRUE?

MK_QSL — Thu, 16 Jul 2015 09:45:12 GMT

Consider below example... This will return as no because not all the values of field is Numeric.

Data:

Load * Inline

[

field

123

ABC

DEF

456

];

LET v_Trace = IF(ISNUM([field]) = -1, 'yes', 'no');

TRACE $(v_Trace);

Re: ISNUM in script returns FALSE while on the GUI, it's TRUE?

datanibbler — Thu, 16 Jul 2015 09:49:13 GMT

Hi Manish,

this seems logical, the variable considers the entire table, about 250.000 records and if one of them is not numeric, it will turn to 'no'.

But in my instance, ALL the values are numeric - if I try it with a new listbox_object on the GUI, I have the two values -1 and 0, but I cannot select 0.

Re: ISNUM in script returns FALSE while on the GUI, it's TRUE?

MK_QSL — Thu, 16 Jul 2015 09:53:11 GMT

Can you share sample file only having this field? also provide how your are using in UI !

Re: ISNUM in script returns FALSE while on the GUI, it's TRUE?

jonathandienst — Thu, 16 Jul 2015 09:55:59 GMT

In the script, [field] has no value, so IsNum correctly returns False return. In the front end, [field] may contain a single value, and could return True.

Re: ISNUM in script returns FALSE while on the GUI, it's TRUE?

tresB — Thu, 16 Jul 2015 09:56:09 GMT

Manish Kachhia

Consider below example... This will return as no because not all the values of field is Numeric.

Data:

Load * Inline

[

field

123

ABC

DEF

456

];

LET v_Trace = IF(ISNUM([field]) = -1, 'yes', 'no');

TRACE $(v_Trace);

because, if you pass field name in isnum() outside load and without any field value position - it actually returns a NULL. And null is not numeric. hope that makes sense.

Re: ISNUM in script returns FALSE while on the GUI, it's TRUE?

datanibbler — Thu, 16 Jul 2015 10:36:20 GMT

Hi Manish,

that would be somewhat difficult as there is a lot of sensitive data that I'm processing here - and there are a lot of fields - and that field which I want to check has actually already been processed because I get it from Excel and the settings rgd. the decimal_separator are wrong, so I switch it around. I think I remember there was also this "it works for everyone else, so i cannot show how it does not work" effect when I first asked about this here ...

The expression in the script is (copied)

LET v_Trace = 'Gesamtzeit ist numerisch: ' & IF(ISNUM(Gesamtzeit_gerundet_syncreon)= (-1), 'ja', 'nein');
TRACE $(v_Trace);
LET v_Trace = 'Umsatz ist numerisch: ' & IF(ISNUM(Kosten_gerechnet_nach_gerundeten_Zeiten)= (-1), 'ja', 'nein');
TRACE $(v_Trace);
LET v_Trace = NULL();

The expression I use on the GUI is

ISNUM(Gesamtzeit_gerundet_syncreon)

and

ISNUM(Kosten_gerechnet_nach_gerundeten_Zeiten)

Best regards,

DataNibbler

Re: ISNUM in script returns FALSE while on the GUI, it's TRUE?

datanibbler — Thu, 16 Jul 2015 10:37:59 GMT

Hi tresesco,

sure that makes sense. So I will delete that code as it potentially leads to some confusion.

Thanks a lot!