topic Re: Load a variable from a a field in QlikView

Load a variable from a a field

Fanch — Wed, 25 Nov 2020 16:16:04 GMT

Hi everybody,

I want to initialize a variable from a field.

I use a script like this :

So, i just want to replace the value 5 by the value MaxNumberCommat.

I've tried Let Vi=Max(Comptelesvirgules) just before For i = 1 to 5, but it does not work 🙄

Thanks in advance for your help

sunny_talwar — Thu, 27 Feb 2020 13:30:30 GMT

Try this after MaxNumberCommat table

LET vMaxNumberCommat = Peek('MaxNumberCommat'); FOR i =1 to $(vMaxNumberCommat)

mfarsln — Thu, 27 Feb 2020 13:34:06 GMT

Hi,

You should use variable to take max value.

After getting max value in table, you should create a variable to carry its value. Then you can use this variable on your for loop.

let vMax = peek('MaxNumberCommat'); for i=1 to $(vMax) . .

oops..Sunny is faster than me 🙂

Fanch — Thu, 27 Feb 2020 13:40:43 GMT

Too strong !!!

Thanks a lot 🍺