topic Re: How to load xml into qlikview in QlikView

How to load xml into qlikview

Thu, 27 Mar 2014 08:27:29 GMT

Hi,

I'm new to qlikview, there is one problem i'm facing is that how to transfer xml into qlikview and filter out the unnecessary data. Also, i want to know is it possible to add in new data but the feature of all tables and charts are never changed. any help is appreciated!

Re: How to load xml into qlikview

arsal_90 — Thu, 27 Mar 2014 08:32:16 GMT

Can u provide the dumy data what type of data is coming through xml or if possible then share your qvw

Re: How to load xml into qlikview

Thu, 27 Mar 2014 08:40:32 GMT

This is the xml i have it contains a lot of data, it's just part of it.

Re: How to load xml into qlikview

mangalsk — Thu, 27 Mar 2014 08:43:27 GMT

Hello,

You can input xml file from table file option

Re: How to load xml into qlikview

arsal_90 — Thu, 27 Mar 2014 08:46:28 GMT

Can u provide xml file then i make qvw for u

Re: How to load xml into qlikview

simsondevadoss — Thu, 27 Mar 2014 13:01:39 GMT

Save the below script in Xml format and import the file in QV.

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

- <Suppliers>

- <_empty_>

<ContactName> Shilton</ContactName>

<Address>49 Gilbert St.</Address>

<City>London</City>

</_empty_>

- <_empty_>

<ContactName>James Brown</ContactName>

<City>New Orleans</City>

</_empty_>

Re: Re: How to load xml into qlikview

mangalsk — Thu, 27 Mar 2014 13:13:48 GMT

Hello,

PFA

I have taken the xml you provided in Qlikview.

Regards,