topic Script fails since large numbers are presented with exponentials as e+008 in QlikView

Script fails since large numbers are presented with exponentials as e+008

andy — Wed, 15 Aug 2012 10:01:28 GMT

Hi Folks,

I have a dilemma with this row in my script.

Concatenate (TestCycl_tmp) LOAD
 $(vMaxTCyId)*100+TC_TESTCYCL_ID as TC_TESTCYCL_ID,

The variable is created like this

Let vMaxTCyId=peek('TC_TESTCYCL_ID', -1,'maxTable');

In QV11 things work as expected and the log file shows

-------------------------------------------------------

Concatenate (TestCycl_tmp) LOAD

228141244*100+TC_TESTCYCL_ID as TC_TESTCYCL_ID,

-------------------------------------------------------

in QV9 it fails and the log looks like

------------------------------------------------

Concatenate (TestCycl_tmp) LOAD

2,2814124e+008*100+TC_TESTCYCL_ID as TC_TESTCYCL_ID,

-------------------------------------------------

The problem is the , (comma) making Qlikview generating a column with just the digit 2.

So how do I force QV9 to present the number with only figures and not exponentials?

brgds

Andy

Re: Script fails since large numbers are presented with exponentials as e+008

Anonymous — Wed, 15 Aug 2012 10:03:39 GMT

Hi,

Try to make the following change:

Let vMaxTCyId=num(peek('TC_TESTCYCL_ID', -1,'maxTable'));

It should help.

Kind regards,

Janusz

Re: Script fails since large numbers are presented with exponentials as e+008

andy — Wed, 15 Aug 2012 10:16:29 GMT

Thank you very much for your fast and correct answer! Now when searching the script I found out that I had used num() on other places but wasn't able to remember after a vacation. Thanks again

/Andy