TablaVariables:
LOAD Variable, Valor
FROM variables.xlsx
(ooxml, embedded labels, table is Hoja1);
let CantVariables=NoOfRows('TablaVariables');
for i=0 to (CantVariables-1)
let vVariable=Peek('Variable',i,'TablaVariables');
let $(vVariable)=Peek('Valor',i,'TablaVariables');
NEXT
El Panel de Variables quedaría así:
LOAD Variable, Valor
FROM variables.xlsx
(ooxml, embedded labels, table is Hoja1);
let CantVariables=NoOfRows('TablaVariables');
for i=0 to (CantVariables-1)
let vVariable=Peek('Variable',i,'TablaVariables');
let $(vVariable)=Peek('Valor',i,'TablaVariables');
NEXT
El Panel de Variables quedaría así:
Referencia: http://community.qlik.com/thread/27883
No hay comentarios:
Publicar un comentario