topic Re: How to drill in missing value ? in QlikView https://community.qlik.com/t5/QlikView/How-to-drill-in-missing-value/m-p/1395522#M612920 <HTML><HEAD></HEAD><BODY><P>You cannot drill into "nothing"..</P></BODY></HTML> Fri, 22 Sep 2017 09:18:54 GMT rbecher 2017-09-22T09:18:54Z How to drill in missing value ? https://community.qlik.com/t5/QlikView/How-to-drill-in-missing-value/m-p/1395518#M612914 <HTML><HEAD></HEAD><BODY><P>Hi All</P><P></P><P></P><P>I have a table it working fine when i click on list full segmentation list.</P><P></P><P></P><P>But when i click on Core segmentation list.</P><P></P><P></P><P>The table display one of the segment = missing value . which is minus sign.</P><P></P><P></P><P>When i click on minus sign to drill in . I am unable to do so.</P><P></P><P></P><P>Can some one advise me how to drill in missing value ? in order for me to figure out the sales value from which company ?</P><P></P><P><IMG alt="care segment.png" class="jive-image image-1" src="/legacyfs/online/177419_care segment.png" style="height: 218px; width: 620px;" /></P><P></P><P>Paul Yeo</P></BODY></HTML> Fri, 22 Sep 2017 08:38:56 GMT https://community.qlik.com/t5/QlikView/How-to-drill-in-missing-value/m-p/1395518#M612914 paulyeo11 2017-09-22T08:38:56Z Re: How to drill in missing value ? https://community.qlik.com/t5/QlikView/How-to-drill-in-missing-value/m-p/1395519#M612916 <HTML><HEAD></HEAD><BODY><P>my QVW file.</P><P>!</P></BODY></HTML> Fri, 22 Sep 2017 08:40:52 GMT https://community.qlik.com/t5/QlikView/How-to-drill-in-missing-value/m-p/1395519#M612916 paulyeo11 2017-09-22T08:40:52Z Re: How to drill in missing value ? https://community.qlik.com/t5/QlikView/How-to-drill-in-missing-value/m-p/1395520#M612918 <HTML><HEAD></HEAD><BODY><P>It's not possible unless you replaced the NULL/MISSING with a real value within the datamodel. Here you will find a very good explanation what are the reasons for NULL and how could you deal with:</P><P></P><P><A href="https://community.qlik.com/docs/DOC-3155">NULL handling in QlikView</A></P><P></P><P>- Marcus</P></BODY></HTML> Fri, 22 Sep 2017 08:45:20 GMT https://community.qlik.com/t5/QlikView/How-to-drill-in-missing-value/m-p/1395520#M612918 marcus_sommer 2017-09-22T08:45:20Z Re: How to drill in missing value ? https://community.qlik.com/t5/QlikView/How-to-drill-in-missing-value/m-p/1395521#M612919 <HTML><HEAD></HEAD><BODY><P>Hi Marcus</P><P></P><P>I have read the article , and it teach me i can hide the null dimension.</P><P></P><P>The issue is if i hide , the value on null diamension will be disappear.</P><P></P><P>Hope some one can share with me, </P><P></P><P>How to drill in null value.</P><P></P><P>Paul Yeo</P></BODY></HTML> Fri, 22 Sep 2017 08:56:04 GMT https://community.qlik.com/t5/QlikView/How-to-drill-in-missing-value/m-p/1395521#M612919 paulyeo11 2017-09-22T08:56:04Z Re: How to drill in missing value ? https://community.qlik.com/t5/QlikView/How-to-drill-in-missing-value/m-p/1395522#M612920 <HTML><HEAD></HEAD><BODY><P>You cannot drill into "nothing"..</P></BODY></HTML> Fri, 22 Sep 2017 09:18:54 GMT https://community.qlik.com/t5/QlikView/How-to-drill-in-missing-value/m-p/1395522#M612920 rbecher 2017-09-22T09:18:54Z Re: How to drill in missing value ? https://community.qlik.com/t5/QlikView/How-to-drill-in-missing-value/m-p/1395523#M612921 <HTML><HEAD></HEAD><BODY><P>Hi Ralf</P><P></P><P>Since it is null , therefore i cannot drill in.</P><P></P><P>It there any way i can figure out where the value come from ?</P><P></P><P>Paul Yeo</P></BODY></HTML> Fri, 22 Sep 2017 09:21:23 GMT https://community.qlik.com/t5/QlikView/How-to-drill-in-missing-value/m-p/1395523#M612921 paulyeo11 2017-09-22T09:21:23Z Re: How to drill in missing value ? https://community.qlik.com/t5/QlikView/How-to-drill-in-missing-value/m-p/1395524#M612922 <HTML><HEAD></HEAD><BODY><P>Please read the posting again - it contained a lot more informations about the NULL handling than just hiding NULL's within the ui. There are various kinds of NULL's and also multiple ways how to deal with them - each one with some benefits and disadvantages and beside the efforts to understand the general topic you will need some time to consider the most suitable approach for your use-case.</P><P></P><P>One addition for possible replacing-approaches is this one: <A href="http://qlikviewcookbook.com/2013/01/filling-default-values-using-mapping/" title="http://qlikviewcookbook.com/2013/01/filling-default-values-using-mapping/">Filling Default Values Using Mapping | Qlikview Cookbook</A>.</P><P></P><P>- Marcus</P></BODY></HTML> Fri, 22 Sep 2017 09:22:33 GMT https://community.qlik.com/t5/QlikView/How-to-drill-in-missing-value/m-p/1395524#M612922 marcus_sommer 2017-09-22T09:22:33Z Re: How to drill in missing value ? https://community.qlik.com/t5/QlikView/How-to-drill-in-missing-value/m-p/1395525#M612923 <HTML><HEAD></HEAD><BODY><P>You need to analyse the source data, the data model and your expressions..</P></BODY></HTML> Fri, 22 Sep 2017 09:34:26 GMT https://community.qlik.com/t5/QlikView/How-to-drill-in-missing-value/m-p/1395525#M612923 rbecher 2017-09-22T09:34:26Z