Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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