Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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

Tags (1)
2 Replies
lironbaram
Honored Contributor II

Re: Loading zero values from xml

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

Re: Loading zero values from xml

It does, thanks

Community Browser