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

[andy]

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

[Anonymous · Accepted solution]

Hi,

Try to make the following change:

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

It should help.

Kind regards,

Janusz

[andy]

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