This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
I have the following SELECT
SQL SELECT name as report_definition_nameFROM reports WHERE reports.active = 1;
name as report_definition_name
FROM reports WHERE reports.active = 1;
My question is how do I iterate over the values of the result set? I want to take the report_definition_name (s) and for each one assign the name to a variable and do something with that.
Thanks in advance
Try the following ...
For i = 1 to NoOfRows('yourtable')
LET varStatic = FieldValue('report_definition_name',$(i)); //Option 1: uses one variable to be used for actions within the loop
SET varName = 'var_$(i)'; LET $(varName) = FieldValue('report_definition_name',$(i)); //Option 2: creates variable for each value so they can be referenced outside of the loop
You will probably need to have distinct row values in the table. If you have a lot of values, the multiple variables option might not be a good idea.
View solution in original post