Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Loading zero values from xml

Hi,

When loading data from xml files using the wizard, records with zero values are being ignored.

For example, when loading the following xml, the table in qlikview will not contain a record for product 2, although I would expact for a record with value "0":

<stock>

     <product>

          <id>1</id>

          <value>22</value>

     </product>

     <product>

          <id>2</id>

          <value>0</value>

     </product>

     <product>

          <id>3</id>

          <value>5</value>

     </product>

</stock>

Does anyone know of a way to load these records?

Thanks

2 Replies
lironbaram
Partner - Master III
Partner - Master III

hi the data is loaded to your document

but if you build a chart table

then probably in the chart properties

under the prsention tab the supress zero values is checked so the chart dosent show products with zero value

hope it helps you

Not applicable
Author

It does, thanks