How to export two charts in one xml file?

Thu, 08 May 2014 09:09:39 GMT

Hi,

I have a problem how to export two charts consecutively in one xml file. I also need to modify some of the tags. I have managed to export those two charts individually. Below are examples for charts how they look right now in xml format. In the first chart I need to remove chart description tag "StraightTableBox" and modify tag's "numberOfOrders" text. I should also add the opening and closing tags for for both of the charts. From chart number two I also need to remove chart description tag "TableBox" and modify tag's "<row>" text. I posted also the macro I used and the desired xml format. How should I modify macro to get desired modifications?

Chart number one:

<?xml version="1.0" encoding="utf-8" standalone="yes"?>

</numberOfOrders>

</StraightTableBox>

Chart number two:

<row>

</row>

<row>

</row>

</TableBox>

Desired xml format:

<?xml version="1.0" encoding="utf-8" standalone="yes"?>

<Title>

<Total>

</Total>

<row>

</row>

<row>

</row>

</Title>

Current macro:

SUB ExportHeader

SET Table = ActiveDocument.GetSheetObject("CH01")

Table.ExportXml "C:\QV\Xml\test.XML"

END SUB

SUB ExportOrders

SET Table2 = ActiveDocument.GetSheetObject("TB01")

Table2.ExportXml "C:\QV\Xml\test2.XML"

END SUB

topic How to export two charts in one xml file? in QlikView

How to export two charts in one xml file?