Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to load xml into qlikview

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!


6 Replies
arsal_90
Creator III
Creator III

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

Not applicable
Author

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

Capturea.PNG.png

mangalsk
Creator III
Creator III

Hello,

You can input xml file from table file option

arsal_90
Creator III
Creator III

Can u provide xml file then i make qvw for u

simsondevadoss
Partner - Creator III
Partner - Creator III

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



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

- <Suppliers>

- <_empty_>

<SupplierID>1</SupplierID>

<CompanyName>gg </CompanyName>

<ContactName> Shilton</ContactName>

<Address>49 Gilbert St.</Address>

<City>London</City>

<PostalCode>EC1 4SD</PostalCode>

<Country>UK</Country>

<Phone>(171) 2333</Phone>

<Fax>(171) 555-31</Fax>

</_empty_>

- <_empty_>

<SupplierID>2</SupplierID>

<CompanyName>Big L</CompanyName>

<ContactName>James Brown</ContactName>

<Address>P.O. Box 78934</Address>

<City>New Orleans</City>

<PostalCode>70117</PostalCode>

<Country>USA</Country>

<Phone>(100) 555-4844</Phone>

<Fax>(100) 555-4944</Fax>

</_empty_>

mangalsk
Creator III
Creator III

Hello,

PFA

I have taken the xml you provided in Qlikview.

Regards,