topic Re: Export Document layout without variable values in QlikView

Export Document layout without variable values

Anonymous — Wed, 09 Sep 2015 18:50:48 GMT

Hello,

I am looking for some help with Export Document Layout Function, I tried creating a new QVW using the layout of another QVW using Export Document Layout function, it worked fine but the variable values are not getting exported, I went through few discussions on this topic but couldn't figure out a way to fix that.

Please let me know if there is a way to have the variable values exported along with the layout.

Thanks

Heera

Re: Export Document layout without variable values

Wed, 09 Sep 2015 18:57:11 GMT

Create variables in a "include text file" in your data script...

Re: Export Document layout without variable values

Anonymous — Wed, 09 Sep 2015 19:31:57 GMT

HI Priyanka,

Thanks for the reply. Are you suggesting to create variables in a text file and call them in the script?

Heera

Re: Export Document layout without variable values

fkeuroglian — Wed, 09 Sep 2015 23:38:49 GMT

Yes!

you can create in xls and call and create in the script

see this example and xls attached

good luck

Fernando K.

In the script you can create with a for (loop) and they will be created in the app

////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

Expresiones:

LOAD NombreExpresion,

ValorExpresion

FROM

$(Path_QVD)Expresiones.qvd(qvd);

LET cantFilasExpresiones = NoOfRows('Expresiones');

FOR i = 1 TO $(cantFilasExpresiones) // recorre linea por linea la tabla Expresiones

LET vNombre = FieldValue('NombreExpresion', $(i));

LET vExpresion = FieldValue('ValorExpresion', $(i));

SET $(vNombre) = $(vExpresion);

NEXT i;