topic Re: Showing null values in QlikView https://community.qlik.com/t5/QlikView/Showing-null-values/m-p/356367#M132263 <HTML><HEAD></HEAD><BODY><P>Ok, what about an additional hidden expression? </P><P><EM>=only({&lt;Date=&gt;} 1)</EM></P></BODY></HTML> Fri, 16 Mar 2012 18:12:49 GMT swuehl 2012-03-16T18:12:49Z Showing null values https://community.qlik.com/t5/QlikView/Showing-null-values/m-p/356361#M132257 <HTML><HEAD></HEAD><BODY><P>My question is how to show null values?</P><P></P><P></P><P>I have two tables</P><P></P><P></P><P>Products</P><P>------------------------------</P><P>IDProduct&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Desc</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Milk</P><P>2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Cookie</P><P>3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Coffee</P><P></P><P></P><P></P><P></P><P>Sales</P><P>-------------------------------------</P><P>Date&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Product&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Quant</P><P>03/16/12&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;20</P><P>03/16/12&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;10</P><P>03/16/12&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;5</P><P>03/14/12&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;10</P><P></P><P></P><P></P><P></P><P>I made a table to show my results filtering date 03/16/2012</P><P>So my result apears:</P><P></P><P></P><P>Product&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Sales</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;30</P><P>3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;5</P><P></P><P></P><P></P><P></P><P>I need to show</P><P></P><P></P><P>Product&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Sales</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;30</P><P>2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;0</P><P>3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;5</P></BODY></HTML> Fri, 16 Mar 2012 15:04:56 GMT https://community.qlik.com/t5/QlikView/Showing-null-values/m-p/356361#M132257 2012-03-16T15:04:56Z Showing null values https://community.qlik.com/t5/QlikView/Showing-null-values/m-p/356362#M132258 <HTML><HEAD></HEAD><BODY><P>I think unchecking the option 'suppress zero values' in presentation tab of your table properties should be enough.</P><P></P><P>Hope this helps,</P><P>Stefan</P></BODY></HTML> Fri, 16 Mar 2012 15:15:36 GMT https://community.qlik.com/t5/QlikView/Showing-null-values/m-p/356362#M132258 swuehl 2012-03-16T15:15:36Z Showing null values https://community.qlik.com/t5/QlikView/Showing-null-values/m-p/356363#M132259 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Go to table properties, then to Presentation tab, select your dimension and uncheck the option "Supress Zero Values"</P></BODY></HTML> Fri, 16 Mar 2012 15:43:37 GMT https://community.qlik.com/t5/QlikView/Showing-null-values/m-p/356363#M132259 jvitantonio 2012-03-16T15:43:37Z Showing null values https://community.qlik.com/t5/QlikView/Showing-null-values/m-p/356364#M132260 <HTML><HEAD></HEAD><BODY><P>It`s not enough.</P></BODY></HTML> Fri, 16 Mar 2012 17:05:07 GMT https://community.qlik.com/t5/QlikView/Showing-null-values/m-p/356364#M132260 2012-03-16T17:05:07Z Re: Showing null values https://community.qlik.com/t5/QlikView/Showing-null-values/m-p/356365#M132261 <HTML><HEAD></HEAD><BODY><P>You also need to check "Show All Values" and "Suppres When Value Is Null" in the dimension sheet.</P><P>Please, see the example attached.</P></BODY></HTML> Fri, 16 Mar 2012 17:08:31 GMT https://community.qlik.com/t5/QlikView/Showing-null-values/m-p/356365#M132261 2012-03-16T17:08:31Z Re: Showing null values https://community.qlik.com/t5/QlikView/Showing-null-values/m-p/356366#M132262 <HTML><HEAD></HEAD><BODY><P>I can't use "show all values" because I need filter by supplier.</P></BODY></HTML> Fri, 16 Mar 2012 17:46:07 GMT https://community.qlik.com/t5/QlikView/Showing-null-values/m-p/356366#M132262 2012-03-16T17:46:07Z Re: Showing null values https://community.qlik.com/t5/QlikView/Showing-null-values/m-p/356367#M132263 <HTML><HEAD></HEAD><BODY><P>Ok, what about an additional hidden expression? </P><P><EM>=only({&lt;Date=&gt;} 1)</EM></P></BODY></HTML> Fri, 16 Mar 2012 18:12:49 GMT https://community.qlik.com/t5/QlikView/Showing-null-values/m-p/356367#M132263 swuehl 2012-03-16T18:12:49Z Re: Showing null values https://community.qlik.com/t5/QlikView/Showing-null-values/m-p/356368#M132264 <HTML><HEAD></HEAD><BODY><P>Sorry but this way don't apear product number 2.</P></BODY></HTML> Fri, 16 Mar 2012 18:22:23 GMT https://community.qlik.com/t5/QlikView/Showing-null-values/m-p/356368#M132264 2012-03-16T18:22:23Z Showing null values https://community.qlik.com/t5/QlikView/Showing-null-values/m-p/356369#M132265 <HTML><HEAD></HEAD><BODY><P>Not sure what you mean by 'doesn't appear product number 2':</P><P></P><P><IMG alt="Product#2.png" class="jive-image-thumbnail jive-image" onclick="" src="https://community.qlik.com/legacyfs/online/12194_Product%232.png" width="450" /></P></BODY></HTML> Fri, 16 Mar 2012 18:32:27 GMT https://community.qlik.com/t5/QlikView/Showing-null-values/m-p/356369#M132265 swuehl 2012-03-16T18:32:27Z Re: Showing null values https://community.qlik.com/t5/QlikView/Showing-null-values/m-p/356370#M132266 <HTML><HEAD></HEAD><BODY><P><IMG alt="qlik.jpg" class="jive-image-thumbnail jive-image" onclick="" src="https://community.qlik.com/legacyfs/online/12192_qlik.jpg" width="450" /></P><P></P><P>Try atach again please. Here don't show product 2.</P></BODY></HTML> Fri, 16 Mar 2012 18:42:44 GMT https://community.qlik.com/t5/QlikView/Showing-null-values/m-p/356370#M132266 2012-03-16T18:42:44Z Showing null values https://community.qlik.com/t5/QlikView/Showing-null-values/m-p/356371#M132267 <HTML><HEAD></HEAD><BODY><P>The attachment works for me.</P><P></P><P>I see you are using 64bit version, while I am working on 32bit right now. Which version are you using, QV11?</P></BODY></HTML> Fri, 16 Mar 2012 19:03:10 GMT https://community.qlik.com/t5/QlikView/Showing-null-values/m-p/356371#M132267 swuehl 2012-03-16T19:03:10Z Re: Showing null values https://community.qlik.com/t5/QlikView/Showing-null-values/m-p/356372#M132268 <HTML><HEAD></HEAD><BODY><P>Version 9.00 (x64)</P></BODY></HTML> Fri, 16 Mar 2012 19:05:56 GMT https://community.qlik.com/t5/QlikView/Showing-null-values/m-p/356372#M132268 2012-03-16T19:05:56Z Re: Showing null values https://community.qlik.com/t5/QlikView/Showing-null-values/m-p/356373#M132269 <HTML><HEAD></HEAD><BODY><P>Ok, I can reproduce your issue on V9 32 bit.</P><P></P><P>This seems to work on this version:</P><P><EM>=only({&lt;Date=&gt;} IDProduct)</EM></P><P></P><P><EM><BR /></EM></P></BODY></HTML> Fri, 16 Mar 2012 19:14:07 GMT https://community.qlik.com/t5/QlikView/Showing-null-values/m-p/356373#M132269 swuehl 2012-03-16T19:14:07Z Showing null values https://community.qlik.com/t5/QlikView/Showing-null-values/m-p/356374#M132270 <HTML><HEAD></HEAD><BODY><P> it's not working for me neither.</P></BODY></HTML> Fri, 16 Mar 2012 19:16:12 GMT https://community.qlik.com/t5/QlikView/Showing-null-values/m-p/356374#M132270 2012-03-16T19:16:12Z Re: Showing null values https://community.qlik.com/t5/QlikView/Showing-null-values/m-p/356375#M132271 <HTML><HEAD></HEAD><BODY><P>Thank you very much friends!</P></BODY></HTML> Fri, 16 Mar 2012 19:57:57 GMT https://community.qlik.com/t5/QlikView/Showing-null-values/m-p/356375#M132271 2012-03-16T19:57:57Z Showing null values https://community.qlik.com/t5/QlikView/Showing-null-values/m-p/356376#M132272 <HTML><HEAD></HEAD><BODY><P>How can I show the same result using pivot table?</P><P></P><P>In pivot table I can't hide expressions.</P><P></P><P>Thanks!</P></BODY></HTML> Mon, 19 Mar 2012 14:23:21 GMT https://community.qlik.com/t5/QlikView/Showing-null-values/m-p/356376#M132272 2012-03-19T14:23:21Z