Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Export Document layout without variable values

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

1 Solution

Accepted Solutions
fkeuroglian
Partner - Master
Partner - Master

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;  

View solution in original post

3 Replies
Not applicable
Author

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

Anonymous
Not applicable
Author

HI Priyanka,

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

Heera

fkeuroglian
Partner - Master
Partner - Master

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;