Variable Max Limit

lawrance — Sat, 25 Mar 2017 18:05:42 GMT

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

Re: Variable Max Limit

hector_munoz — Sat, 25 Mar 2017 20:54:50 GMT

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);

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

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);

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

I hope it serves...

Regards,

topic Re: Variable Max Limit in QlikView

Variable Max Limit

Re: Variable Max Limit