topic Re: Reading XML script in QlikView

Reading XML script

Sun, 21 Jun 2015 05:55:24 GMT

Hi All

Please help in understanding the XML script generated by qlikview. Below script are generated in the Chart export to xml script.

<Pos>

</ElemNo>

<Blob>

AgAAAABAzuBA

</Blob>

</ElemValues>

</Pos>

Thanks in Advance

Veena

Re: Reading XML script

Sun, 21 Jun 2015 15:33:36 GMT

Hi, Generally we can export the data from objects into txt , excel , xml , html files. So you can you these files into some other programs or you can reload into qlikview as well.

If you need more about xml script , Please look xml tutorials.

Re: Reading XML script

Sun, 21 Jun 2015 16:02:53 GMT

Hi Dathu

Sorry ..if I was not clear with my question. I would like to know what is the <BLOB> tag in that script referring to in a Pivot Chart and what type of code is 'AgAAAABAzuBA'

Thanks

Veena

Re: Reading XML script

Sun, 21 Jun 2015 16:43:18 GMT

Which version you are using ? can you please post the your sample QVW.

I didn't see any Data Type on my chart export to xml.

You can load the output XML into another qvw and see the results.

Re: Reading XML script

Sun, 21 Jun 2015 18:15:18 GMT

I am using SR11. I tried importing and didn't find any difference in UI. Also I tried to replicate the same in a sample qvw by pivoting, conditional display, minimize and maximize option. But all were unsuccessful.I will try to see whether I can post a sample qvw.

Re: Reading XML script

petter — Sun, 21 Jun 2015 20:00:50 GMT

BLOB is usually an abbreviation of Binary Large OBject. In this context it is maybe a compressed or binary representation that QlikView does not see necessary to make into a readable value in the XML. QlikView will be able to read it back into some sensible information.

Re: Reading XML script

Mon, 22 Jun 2015 01:19:50 GMT

Does it mean that value in the XML is a pointer and BLOB data is stored in Server?

Re: Reading XML script

jagan — Mon, 22 Jun 2015 02:40:50 GMT

Hi Veena,

How you got this XML? Right click on Chart and Export -> XML? When we export to XML usually you will get data in the below format

- <_x0031_00>

<_x0031_00>100</_x0031_00>

</_x0031_00>

- <_x0031_00>

<_x0031_00>100</_x0031_00>

</_x0031_00>--

</PivotTable>

Do you have any images in your Pivot Table? Can you upload the file which you are using so that it would be easier to find the issue.

Regards,

jagan.

Re: Reading XML script

Mon, 22 Jun 2015 05:28:55 GMT

Hi Jagan

File-->Export -->Export Document Layout. It will create xml script for all objects.

Thanks

Veena

Re: Reading XML script

jagan — Mon, 22 Jun 2015 06:01:53 GMT

Hi,

What you are trying to do with this XML? When you export you will get multiple XML files, which has definitions for Document, Sheets and chart objects.

Regards,

Jagan.

Re: Reading XML script

Mon, 22 Jun 2015 06:41:07 GMT

I am trying to export this script and not able to understand the usage of this <BLOB> content. I am not seeing any impact if I remove this Tag.

Regards

Veena

Re: Reading XML script

jagan — Mon, 22 Jun 2015 06:57:04 GMT

Hi,

Generally BLOB will store the contents of images etc. I am not sure which export file you are referring.

Regards,

jagan.

Re: Reading XML script

Mon, 22 Jun 2015 15:41:28 GMT

What is main purpose of this export. If you doing Export Document Layout it creates all objects xml.