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.
We have an Excel with a seperate tab for all the KPI's with the expressions we use in the QV dashboard.I'm trying to create a loop so all variables will be automaticly be created.
I'm trying to do something like this:
KPI:LOAD KPICode, KPI AS KPI_Desc, Expression AS KPI_ExpressionFROM[..\Nav_Aansturing\Qlikview control file.xlsx](ooxml, embedded labels, table is [KPI's])Where not IsNull(KPI);
LET vKPI = NoOfRows('KPI');
For i = 1 to $(vKPI)
LET $(i)_vKPICode = FieldValue('KPI_Expression',$(i));
The thing is that I can not make it work that the variable name is created with a variabele name.I Have added the Excel file with variabele I want to create.
Thanks for the help
You can use the following approach
FOR var_i = 1 TO NOOFROWS('KPI')
l_var = PEEK('KPICode, var_i - 1, 'KPI');
l_val = PEEK('KPI_Expression', var_i - 1, 'KPI');
SET $(l_var) = $(l_val);
View solution in original post
this script will help you...
vKPI = NoOfRows('KPI');For i = 1 to $(vKPI) Let Variable = FieldValue('KPICode',$(i)); LET $(Variable) = FieldValue('KPI_Expression',$(i));NEXT i;
Thanks for your quick help.
It works the way I wanted.
Your approach also works.
Thanks for your help as well.