topic Showing null values in QlikView https://community.qlik.com/t5/QlikView/Showing-null-values/m-p/359006#M133243 <HTML><HEAD></HEAD><BODY><P>Where I put NullAsValue ?</P></BODY></HTML> Tue, 20 Mar 2012 12:46:12 GMT 2012-03-20T12:46:12Z Showing null values https://community.qlik.com/t5/QlikView/Showing-null-values/m-p/359004#M133241 <HTML><HEAD></HEAD><BODY><P>I need show null values in a Pivot table. Somebody help-me?</P><P></P><P>Cause I need analise productos without any sale.</P><P></P><P><IMG alt="my case.png" class="jive-image-thumbnail jive-image" onclick="" src="https://community.qlik.com/legacyfs/online/12254_my+case.png" width="450" /></P></BODY></HTML> Mon, 19 Mar 2012 20:32:33 GMT https://community.qlik.com/t5/QlikView/Showing-null-values/m-p/359004#M133241 2012-03-19T20:32:33Z Showing null values https://community.qlik.com/t5/QlikView/Showing-null-values/m-p/359005#M133242 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Depends on whether you want to show null values, or display the dimensions even when there is no data against that dimension:</P><P></P><P>If null, use NullAsValue &lt;fieldname&gt; to replace null values with blanks (which are valid values, and will display in liat boxes etc).</P><P></P><P>If missing, you need an island dimension to show the dimension values even when there is no data. Search the forum for "date island" or "island adimension" for examples.</P><P></P><P>Regards</P><P>Jonathan</P></BODY></HTML> Mon, 19 Mar 2012 21:07:08 GMT https://community.qlik.com/t5/QlikView/Showing-null-values/m-p/359005#M133242 jonathandienst 2012-03-19T21:07:08Z Showing null values https://community.qlik.com/t5/QlikView/Showing-null-values/m-p/359006#M133243 <HTML><HEAD></HEAD><BODY><P>Where I put NullAsValue ?</P></BODY></HTML> Tue, 20 Mar 2012 12:46:12 GMT https://community.qlik.com/t5/QlikView/Showing-null-values/m-p/359006#M133243 2012-03-20T12:46:12Z Showing null values https://community.qlik.com/t5/QlikView/Showing-null-values/m-p/359007#M133244 <HTML><HEAD></HEAD><BODY><P>I tryed but don't work.&nbsp; Sorry.</P></BODY></HTML> Tue, 20 Mar 2012 12:51:28 GMT https://community.qlik.com/t5/QlikView/Showing-null-values/m-p/359007#M133244 2012-03-20T12:51:28Z Showing null values https://community.qlik.com/t5/QlikView/Showing-null-values/m-p/359008#M133245 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Properties--&gt;Presentation--&gt;Uncheck the suppress zero values option.</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Properties--&gt;Dimension--&gt;Check the Show all values options</P><P></P><P>Celambarasan</P></BODY></HTML> Tue, 20 Mar 2012 13:01:27 GMT https://community.qlik.com/t5/QlikView/Showing-null-values/m-p/359008#M133245 CELAMBARASAN 2012-03-20T13:01:27Z Re: Showing null values https://community.qlik.com/t5/QlikView/Showing-null-values/m-p/359009#M133246 <HTML><HEAD></HEAD><BODY><P>Hi, Afranio. </P><P>I'm not sure if this will be enough in your case, but in the 'Dimensions' tab of the object properties, you can enable the check box 'Show All Values' </P><P></P><P>I updated your app with this property.</P><P>Hope this helps, </P><P></P><P>Erich</P></BODY></HTML> Tue, 20 Mar 2012 13:05:11 GMT https://community.qlik.com/t5/QlikView/Showing-null-values/m-p/359009#M133246 erichshiino 2012-03-20T13:05:11Z Showing null values https://community.qlik.com/t5/QlikView/Showing-null-values/m-p/359010#M133247 <HTML><HEAD></HEAD><BODY><P>I can't use Show All Values cause I need filter by Customer and/or Supliers. Sorry</P><P></P><P>Regards!</P></BODY></HTML> Tue, 20 Mar 2012 13:33:49 GMT https://community.qlik.com/t5/QlikView/Showing-null-values/m-p/359010#M133247 2012-03-20T13:33:49Z Showing null values https://community.qlik.com/t5/QlikView/Showing-null-values/m-p/359011#M133248 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; What output are you trying to achieve?</P><P></P><P>Celambarasan</P></BODY></HTML> Tue, 20 Mar 2012 13:39:22 GMT https://community.qlik.com/t5/QlikView/Showing-null-values/m-p/359011#M133248 CELAMBARASAN 2012-03-20T13:39:22Z Showing null values https://community.qlik.com/t5/QlikView/Showing-null-values/m-p/359012#M133249 <HTML><HEAD></HEAD><BODY><P>I need filter</P><P></P><P></P><P>Date = 03/16/2012</P><P>Suplier = xMARKET</P><P>Customer = All</P><P></P><P></P><P>Pivot table will be:</P><P></P><P></P><P></P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Afranio&nbsp;&nbsp;&nbsp;&nbsp; Neymar</P><P>Milk&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;30&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;0 </P><P>Cookie&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0</P><P>Coffee&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;0</P><P></P><P></P><P>----------------------------------------</P><P></P><P></P><P>If I filter:</P><P></P><P></P><P>Date = 03/14/2012</P><P>Suplier = xMARKET</P><P>Customer = All</P><P></P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Afranio&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Neymar</P><P>Milk&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;5 </P><P>Cookie&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;0</P><P>Coffee&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0</P><P></P><P></P><P></P><P></P><P>----------------------------------------</P><P></P><P></P><P>If I filter:</P><P></P><P></P><P>Date = 03/14/2012</P><P>Suplier = xMARKET</P><P>Customer = Afranio</P><P></P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Afranio </P><P>Milk&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;0 </P><P>Cookie&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10 </P><P>Coffee&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0 </P></BODY></HTML> Tue, 20 Mar 2012 13:57:14 GMT https://community.qlik.com/t5/QlikView/Showing-null-values/m-p/359012#M133249 2012-03-20T13:57:14Z Showing null values https://community.qlik.com/t5/QlikView/Showing-null-values/m-p/359013#M133250 <HTML><HEAD></HEAD><BODY><P>Is it possible&nbsp; with Qlikview? Domebody can help-me ?</P></BODY></HTML> Tue, 20 Mar 2012 20:16:51 GMT https://community.qlik.com/t5/QlikView/Showing-null-values/m-p/359013#M133250 2012-03-20T20:16:51Z Re: Showing null values https://community.qlik.com/t5/QlikView/Showing-null-values/m-p/359014#M133251 <HTML><HEAD></HEAD><BODY><P>How about this?</P></BODY></HTML> Wed, 21 Mar 2012 10:26:13 GMT https://community.qlik.com/t5/QlikView/Showing-null-values/m-p/359014#M133251 2012-03-21T10:26:13Z Re: Showing null values https://community.qlik.com/t5/QlikView/Showing-null-values/m-p/359015#M133252 <HTML><HEAD></HEAD><BODY><P>No. Because I need show all products from supplier "xMarket".&nbsp; I need analise all products with sale or not.</P><P></P><P>Thanks.</P></BODY></HTML> Wed, 21 Mar 2012 11:56:54 GMT https://community.qlik.com/t5/QlikView/Showing-null-values/m-p/359015#M133252 2012-03-21T11:56:54Z