Variable's value in -prj folder xml - Qlik Community

bluecarbon · ‎2016-03-01

Hi,

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

Thanks,

Rakul.

Peter_Cammaert · ‎2016-03-01

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

swuehl · ‎2016-03-01

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>

bluecarbon · ‎2016-03-01

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.

bluecarbon · ‎2016-03-01

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

Thanks,

Rakul

Peter_Cammaert · ‎2016-03-01

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

Peter_Cammaert · ‎2016-03-01

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

bluecarbon · ‎2016-03-01

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.

swuehl · ‎2016-03-01

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.

bluecarbon · ‎2016-03-01

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.