topic Select first non null value in QlikView https://community.qlik.com/t5/QlikView/Select-first-non-null-value/m-p/194511#M55385 <HTML><HEAD></HEAD><BODY><P>Is there a function in Qlickview with will return the first non null value.</P><P></P><P>I am trying to do away with having to use multiple nested if statements.</P><P></P></BODY></HTML> Thu, 25 Mar 2010 23:01:34 GMT alan_grn 2010-03-25T23:01:34Z Select first non null value https://community.qlik.com/t5/QlikView/Select-first-non-null-value/m-p/194511#M55385 <HTML><HEAD></HEAD><BODY><P>Is there a function in Qlickview with will return the first non null value.</P><P></P><P>I am trying to do away with having to use multiple nested if statements.</P><P></P></BODY></HTML> Thu, 25 Mar 2010 23:01:34 GMT https://community.qlik.com/t5/QlikView/Select-first-non-null-value/m-p/194511#M55385 alan_grn 2010-03-25T23:01:34Z Select first non null value https://community.qlik.com/t5/QlikView/Select-first-non-null-value/m-p/194512#M55386 <HTML><HEAD></HEAD><BODY><P>Hello Alan,</P><P>Depending on how is your data base sorted, you have two functions to get a non null value. One is</P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">If(Not IsNull(Field), Field)</PRE></BLOCKQUOTE>but I prefer to use <BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">If(Len(Field) &gt; 0, Field)</PRE></BLOCKQUOTE>Is that what you are looking for?<BR /><BR /></BODY></HTML> Fri, 26 Mar 2010 08:13:33 GMT https://community.qlik.com/t5/QlikView/Select-first-non-null-value/m-p/194512#M55386 Miguel_Angel_Baeyens 2010-03-26T08:13:33Z Select first non null value https://community.qlik.com/t5/QlikView/Select-first-non-null-value/m-p/194513#M55387 <HTML><HEAD></HEAD><BODY><P>The way to avoid null in your situation is to put distinct like this: firstsortedvalue( distinct ...</P><P>In my case working perfectly, hope it will help.</P></BODY></HTML> Sun, 23 Jan 2011 23:41:11 GMT https://community.qlik.com/t5/QlikView/Select-first-non-null-value/m-p/194513#M55387 2011-01-23T23:41:11Z