topic How to ingnore the nulls in this expression? in QlikView https://community.qlik.com/t5/QlikView/How-to-ingnore-the-nulls-in-this-expression/m-p/281661#M104778 <HTML><HEAD></HEAD><BODY><P>Hello Experts,</P><P></P><P>I have a funnel chart on which I have a <STRONG>dimension </STRONG>like <STRONG>=if(PipeStatus_Reached_opp_key &gt;=1,PipeName)</STRONG></P><P><STRONG> </STRONG></P><P>And and expression <STRONG>=rangesum(below(count({&lt; dim_opportunity_master.Effective_end ={'31/12/9999'}&gt;}&nbsp; distinct dim_opportunity_master.crm_opportunity_id),0,6))</STRONG></P><P><STRONG> </STRONG></P><P>The problem I have is, looks like there are some null values on selected Calendar Date due to which one of the dimensions is blank and supressed and my chart doesnt look good. I want to see the next value in place of null value when something is null or blank.</P><P></P><P>Please look at the original post where I have attached a sample: <A _jive_internal="true" href="https://community.qlik.com/message/141712#141712">http://community.qlik.com/message/141712#141712</A> if you need more info.</P><P></P><P></P><P>Thanks a ton in advance,</P><P>Mady</P></BODY></HTML> Thu, 18 Aug 2011 08:43:54 GMT 2011-08-18T08:43:54Z How to ingnore the nulls in this expression? https://community.qlik.com/t5/QlikView/How-to-ingnore-the-nulls-in-this-expression/m-p/281661#M104778 <HTML><HEAD></HEAD><BODY><P>Hello Experts,</P><P></P><P>I have a funnel chart on which I have a <STRONG>dimension </STRONG>like <STRONG>=if(PipeStatus_Reached_opp_key &gt;=1,PipeName)</STRONG></P><P><STRONG> </STRONG></P><P>And and expression <STRONG>=rangesum(below(count({&lt; dim_opportunity_master.Effective_end ={'31/12/9999'}&gt;}&nbsp; distinct dim_opportunity_master.crm_opportunity_id),0,6))</STRONG></P><P><STRONG> </STRONG></P><P>The problem I have is, looks like there are some null values on selected Calendar Date due to which one of the dimensions is blank and supressed and my chart doesnt look good. I want to see the next value in place of null value when something is null or blank.</P><P></P><P>Please look at the original post where I have attached a sample: <A _jive_internal="true" href="https://community.qlik.com/message/141712#141712">http://community.qlik.com/message/141712#141712</A> if you need more info.</P><P></P><P></P><P>Thanks a ton in advance,</P><P>Mady</P></BODY></HTML> Thu, 18 Aug 2011 08:43:54 GMT https://community.qlik.com/t5/QlikView/How-to-ingnore-the-nulls-in-this-expression/m-p/281661#M104778 2011-08-18T08:43:54Z