topic How to copy variable from one doc to another qv doc ? in QlikView

How to copy variable from one doc to another qv doc ?

Thu, 19 Dec 2013 07:19:31 GMT

Hi All

In setting variable I can create variety

I need to copy all . Instead of manually create one by one.

Any fast way ?

Re: How to copy variable from one doc to another qv doc ?

Anonymous — Thu, 19 Dec 2013 17:01:14 GMT

Paul

Put the variable definitions in an external qvs script file and include in them in your qvw's with an Include or MustInclude statement.

Best Regards, Bill

Re: How to copy variable from one doc to another qv doc ?

afurtado — Thu, 19 Dec 2013 17:06:09 GMT

Hi.

I have an document that show how to recovery from -prj

AMF

Re: How to copy variable from one doc to another qv doc ?

Thu, 19 Dec 2013 23:52:25 GMT

Hi Bill

Thank . But I not able to understand. What I mean is one of my doc have 50 variable plus expression. I need to copy to 5 of my QV doc. I lazy to start new doc . Just want to add vat.

Sent from Samsung Mobile

Re: How to copy variable from one doc to another qv doc ?

Fri, 20 Dec 2013 14:44:57 GMT

Hi Ales

Thank you for your document. it help a lot .

Paul

Re: How to copy variable from one doc to another qv doc ?

flipside — Fri, 20 Dec 2013 15:22:57 GMT

You can also read direct from the QVW ...

ReadVars:

LOAD Name, RawValue
FROM [doc1.qvw] (XmlSimple, Table is [DocumentSummary/VariableDescription])
where IsConfig='false' and IsReserved='false';

For i = 0 to NoOfRows('ReadVars')

Let n = peek('Name',i,'ReadVars');

Let $(n) = peek('RawValue',i,'ReadVars');

next i;

Let i = Nothing;

Drop Table ReadVars;

flipside

Re: How to copy variable from one doc to another qv doc ?

Fri, 20 Dec 2013 15:59:37 GMT

We can't get the Variable definition from -prj folder XML file.

Re: How to copy variable from one doc to another qv doc ?

Sun, 22 Dec 2013 01:29:22 GMT

Hi Dathu

Do you mean the script propose by this post is unable to work ?

Paul

Re: How to copy variable from one doc to another qv doc ?

Mon, 23 Dec 2013 19:23:25 GMT

Hi Paul, I am not recovering the variable definition from the method proposed in pdf file. for example, i have variables in the script like below:

LET vSales = 'sum(SALE_AMT)';

LET vYTDSales = 'sum({<YTD_FLAG={1}>}SALE_AMY)';

I recovered only variable names only,vSales and vYTDSales not both variable name and variable definition.

Re: How to copy variable from one doc to another qv doc ?

Fri, 26 Sep 2014 11:59:14 GMT

Very Good!

Thanks

Re: How to copy variable from one doc to another qv doc ?

Anonymous — Thu, 13 Sep 2018 04:02:40 GMT

This worked for me