topic Re: Variable's value in -prj folder xml in QlikView

Variable's value in -prj folder xml

bluecarbon — Tue, 01 Mar 2016 20:07:06 GMT

Hi,

Where can I find a the value or content of a variable in xml files generated in -prj folder.

Thanks,

Rakul.

Re: Variable's value in -prj folder xml

Peter_Cammaert — Tue, 01 Mar 2016 20:34:02 GMT

Nowhere.

That's one of the issues with exporting QVW documents to a -prj directory. Variable values don't survive the export.

In most cases, you could mitigate this weakness by (re)defining your variables in your load script. Which is a best practice anyway.

Best,

Peter

Re: Variable's value in -prj folder xml

swuehl — Tue, 01 Mar 2016 20:43:43 GMT

Not sure what you are trying to achieve.

Maybe it's an option to parse the XML code that is part of each QVW (you can load the XML code e.g. using the QV wizard), it looks like

<IsConfig>false</IsConfig>

<IsReserved>false</IsReserved>

</VariableDescription>

Re: Variable's value in -prj folder xml

bluecarbon — Tue, 01 Mar 2016 20:49:23 GMT

I tried creating -prj folder for a QVW with variable and then deleted the QVW. When I created a blank QVW and saved it with the same name as -prj folder, I got the variables back with expressions in it. Wondering where exactly this information is stored and getting recreated.

Thanks,

Rakul.

Re: Variable's value in -prj folder xml

bluecarbon — Tue, 01 Mar 2016 20:52:50 GMT

Please explain me how the above XML is created out of a QVW file.

Thanks,

Rakul

Re: Variable's value in -prj folder xml

Peter_Cammaert — Tue, 01 Mar 2016 21:02:31 GMT

Did you do a reload? The empty document was created using File->New?

If I do what you tell me you did, I (still) get a nice document with a series of empty variables. Using 11.20SR12

Re: Variable's value in -prj folder xml

Peter_Cammaert — Tue, 01 Mar 2016 21:05:02 GMT

Every QVW or QVD file contains an XML header that describes various properties of that particular file (including table layout and data lineage).

That header can be read into QlikView by opening the file using the XML import filter.

Peter

Re: Variable's value in -prj folder xml

bluecarbon — Tue, 01 Mar 2016 21:07:25 GMT

I just saved it with the same name as -prj folder and closed it and opened it again. But I was seeing all system configuration variables too listed in the variable overview. Below is the steps to recreate.

1.Create a QVW with name var.qvw and created few variables in it.

2. Saved it and closed it.

3. Created a folder var-prj in the same location where qvw is stored.

4. Open the var.qvw and click save and close it.

5. Delete var.qvw

6. Create a blank qvw and save it as var under same location where it was deleted and close it.

7. Now open the var.qvw and you will be seeing all variables listed in AllProperties.XML file in var.qvw variable overview.

Thanks,

Rakul.

Re: Variable's value in -prj folder xml

swuehl — Tue, 01 Mar 2016 21:09:03 GMT

With QV12, look into AllProperties.xml.

I somehow mixed up the files. AllProperties.xml still only contains the properties of the variables, not the content.

Re: Variable's value in -prj folder xml

bluecarbon — Tue, 01 Mar 2016 21:14:41 GMT

Hi,

I opened a qvw file in WordPad and I was able to see the xml having values of Variable Description. But still not in any other xml files generated inside -prj folder of QV11 version.

Thanks,

Rakul.

Re: Variable's value in -prj folder xml

Peter_Cammaert — Tue, 01 Mar 2016 22:31:42 GMT

AllProperties.xml will contain all variables that were defined in the original document, including the system variables that are automatically created during the first reload. But not their content.

In step 6, do you get an invitation to overwrite the project files?

Re: Variable's value in -prj folder xml

Peter_Cammaert — Tue, 01 Mar 2016 22:39:03 GMT

Oh, I get it.

I think you're looking at the Comment property which is indeed saved together with all other variable properties to AllProperties.xml (see the bottom field of the Settings->Variable overview dialog). However, that's not the variable value as listed in the Definition field (middle one in Variable overview)

Re: Variable's value in -prj folder xml

Anonymous — Thu, 05 Jan 2017 08:51:43 GMT

What if you load the current QVW back into itself as XML at the end of the load script, mind blowing I know

You can then store the variables out into the -PRJ folder as a text file, with this method you will also be able to use source control on

the -PRJ folder as it will have your variables text file in it.

The only issue you would have is having to reload your document every time you create or make changes to your variables for them to be visible in your variable output text file.