Variable Max Limit

[lawrance]

Hi,

What is the Maximum value can store it in QlikView variable.

Is there any Limit to store the value in QlikView variable?

If it numeric, what is max length can store it in QlikView variable?

Thanks,

Lawrance A

[hector_munoz]

Hi Lawrance,

If you store a numeric value in the variable, I think the limit is near to 1E300. I have used the folowing script:

SET vsLimit

= 1;

FOR vsContador = 1 TO 1000

	LET vsLimit = $(vsLimit) * 10;
	TRACE $(vsLimit);
	TRACE $(vsContador);

NEXT

, and I have found error in iteration 301. At iteration 300 the variable was not able to store the value proposed:

NEXT

2017-03-25 21:42:21 0024   LET vsLimit = 1e+297 * 10

2017-03-25 21:42:21 0025   TRACE 1e+298

2017-03-25 21:42:21 0025   1e+298

2017-03-25 21:42:21 0026  

2017-03-25 21:42:21 0026   TRACE 298

2017-03-25 21:42:21 0026   298

2017-03-25 21:42:21 0027  

2017-03-25 21:42:21 0028   NEXT

2017-03-25 21:42:21 0024   LET vsLimit = 1e+298 * 10

2017-03-25 21:42:21 0025   TRACE 1e+299

2017-03-25 21:42:21 0025   1e+299

2017-03-25 21:42:21 0026  

2017-03-25 21:42:21 0026   TRACE 299

2017-03-25 21:42:21 0026   299

2017-03-25 21:42:21 0027  

2017-03-25 21:42:21 0028   NEXT

2017-03-25 21:42:21 0024   LET vsLimit = 1e+299 * 10

2017-03-25 21:42:21 0025   TRACE

2017-03-25 21:42:21 0025  

2017-03-25 21:42:21 0026  

2017-03-25 21:42:21 0026   TRACE 300

2017-03-25 21:42:21 0026   300

2017-03-25 21:42:21 0027  

2017-03-25 21:42:21 0028   NEXT

2017-03-25 21:42:21 0024   LET vsLimit =  * 10

2017-03-25 21:42:21           Error: Línea de error de Script:

2017-03-25 21:42:22 0025   TRACE

2017-03-25 21:42:22 0025  

If you store an alphanumeric value in the variable, I have not found the limit in a string of 10.000 characters. I have used the folowing script:

SET vsLimit

= '';

FOR vsContador = 1 TO 10000

	LET vsLimit = '$(vsLimit)' & 'a';
	TRACE $(vsLimit);
	TRACE $(vsContador);

NEXT

, but the variable still can store the value or the iteration. I donot want mi PC to be burned... 😉

I hope it serves...

Regards,

H