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.
Hey! Is there a possibility to assign table names in a for loop that looks like follows:
for each vSheet in 'A', 'B', 'C'
load F1, F2, F3
from [data.xlsx](ooxml, embedded labels, table is $(vSheet));
wheras the table names should be different for each of the 3 uploads?
simply use the for loop variable?
also make sure you use noconcatenate if you want distinct tables
Thanks for the answer, but is there also a way in using a table name other than the loop variable?
Sure, you could calculate the label in a variable, and use that.
e.g. LET TableLabel = IF($(vSheet) = 'A', 'New Label', 'Label for B and C')
Thanks for the answer, but now I get for all tables the new name that I assigned to A even for B and C. The table names look like that:
'NewLabel', 'NewLabel-1', 'NewLabel-2'
Any idea why I the IF statement doesn't work as required?
How does your if() look?
Basically as yours I think:
if($(vSheet) = 'A', 'NewA', 'NewBC')
The variable vSheet does might not need the $() expansion.
if(vSheet = 'A', 'NewA', 'NewBC')
This results in the same problem as before with the difference that its now happening with 'NewBC'