topic Re: Loading zero values from xml in QlikView https://community.qlik.com/t5/QlikView/Loading-zero-values-from-xml/m-p/437035#M697842 <HTML><HEAD></HEAD><BODY><P>It does, thanks <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Sun, 20 Jan 2013 14:59:55 GMT 2013-01-20T14:59:55Z Loading zero values from xml https://community.qlik.com/t5/QlikView/Loading-zero-values-from-xml/m-p/437033#M697840 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>When loading data from xml files using the wizard, records with zero values are being ignored.</P><P></P><P>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":</P><P></P><P>&lt;stock&gt;</P><P>&nbsp;&nbsp;&nbsp;&nbsp; &lt;product&gt;</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;id&gt;1&lt;/id&gt;</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;value&gt;22&lt;/value&gt;</P><P>&nbsp;&nbsp;&nbsp;&nbsp; &lt;/product&gt;</P><P>&nbsp;&nbsp;&nbsp;&nbsp; &lt;product&gt;</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;id&gt;2&lt;/id&gt;</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;value&gt;0&lt;/value&gt;</P><P>&nbsp;&nbsp;&nbsp;&nbsp; &lt;/product&gt;</P><P>&nbsp;&nbsp;&nbsp;&nbsp; &lt;product&gt;</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;id&gt;3&lt;/id&gt;</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;value&gt;5&lt;/value&gt;</P><P>&nbsp;&nbsp;&nbsp;&nbsp; &lt;/product&gt;</P><P>&lt;/stock&gt;</P><P></P><P>Does anyone know of a way to load these records?</P><P></P><P>Thanks</P></BODY></HTML> Sun, 20 Jan 2013 14:32:43 GMT https://community.qlik.com/t5/QlikView/Loading-zero-values-from-xml/m-p/437033#M697840 2013-01-20T14:32:43Z Re: Loading zero values from xml https://community.qlik.com/t5/QlikView/Loading-zero-values-from-xml/m-p/437034#M697841 <HTML><HEAD></HEAD><BODY><P>hi the data is loaded to your document </P><P>but if you build a chart table </P><P>then probably in the chart properties</P><P>under the prsention tab the supress zero values is checked so the chart dosent show products with zero value</P><P>hope it helps you</P></BODY></HTML> Sun, 20 Jan 2013 14:38:01 GMT https://community.qlik.com/t5/QlikView/Loading-zero-values-from-xml/m-p/437034#M697841 lironbaram 2013-01-20T14:38:01Z Re: Loading zero values from xml https://community.qlik.com/t5/QlikView/Loading-zero-values-from-xml/m-p/437035#M697842 <HTML><HEAD></HEAD><BODY><P>It does, thanks <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Sun, 20 Jan 2013 14:59:55 GMT https://community.qlik.com/t5/QlikView/Loading-zero-values-from-xml/m-p/437035#M697842 2013-01-20T14:59:55Z