![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEisHtPHTTu2GQKgTlpekMzb_znxOUjDyhAFKyrPTfWUq9XvVLCKM8QIc7iN1dgNycoGeFHDCCf4L8pxzqytFxZmzX4PNZdrubMYc24mSZ72K1k1Y0IV_MbyavS8Oqwt2r8dz3YEg-KXH-0/s1600/Variables.jpg)
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