Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Fanch
Partner - Creator
Partner - Creator

Load a variable from a a field

Hi everybody,

I want to initialize a variable from a field.

I use a script like this :

Capture.JPG

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 

 

 

 

1 Solution

Accepted Solutions
sunny_talwar

Try this after MaxNumberCommat table

LET vMaxNumberCommat = Peek('MaxNumberCommat');

FOR i =1 to $(vMaxNumberCommat)

View solution in original post

3 Replies
sunny_talwar

Try this after MaxNumberCommat table

LET vMaxNumberCommat = Peek('MaxNumberCommat');

FOR i =1 to $(vMaxNumberCommat)
mfarsln
Creator II
Creator II

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
Partner - Creator
Partner - Creator
Author

Too strong !!! 

Thanks a lot 🍺