Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
Please help in understanding the XML script generated by qlikview. Below script are generated in the Chart export to xml script.
<Pos>
<DimName>Id</DimName>
<ElemNo>
<int>2392</int>
</ElemNo>
<ElemValues>
<Blob>
AgAAAABAzuBA
</Blob>
</ElemValues>
</Pos>
Thanks in Advance
Veena
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.
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
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.
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.
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.
Does it mean that value in the XML is a pointer and BLOB data is stored in Server?
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
<PivotTable>
Hi Jagan
File-->Export -->Export Document Layout. It will create xml script for all objects.
Thanks
Veena
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.