topic Re: Set Analisys with a Null () function in QlikView https://community.qlik.com/t5/QlikView/Set-Analisys-with-a-Null-function/m-p/652144#M238422 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>Set analysis to exclude null values (or actually include all non Null values) might be set as follows</P><P></P><P><STRONG>SUM({$&lt;OrderRequestDate = {*}&gt;} If(OrderDate&gt;OrderRequestDate, NetWorkDays(OrderRequestDate,OrderDate)-1,0))/Count(OrderID)</STRONG></P></BODY></HTML> Fri, 17 Oct 2014 10:50:51 GMT d_pranskus 2014-10-17T10:50:51Z Set Analisys with a Null () function https://community.qlik.com/t5/QlikView/Set-Analisys-with-a-Null-function/m-p/652142#M238420 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I'd like to sum the dalay between the order emission and the order request dates.</P><P></P><P>Data are valid only when the request date is not null, so I tried to reach the goal with the above formula:</P><P>Sum({ $&lt;OrderRequestDate&lt;&gt;{Null()}&gt;} If(OrderDate&gt;OrderRequestDate,NetWorkDays(OrderRequestDate,OrderDate)-1,0))/Count(OrderID)</P><P></P><P>...but it doesn't work <span class="lia-unicode-emoji" title=":disappointed_face:">😞</span></P><P></P><P>Would someone help me, pls?</P><P></P><P>Thanks.</P><P></P><P>N.</P></BODY></HTML> Fri, 17 Oct 2014 10:28:39 GMT https://community.qlik.com/t5/QlikView/Set-Analisys-with-a-Null-function/m-p/652142#M238420 Anonymous 2014-10-17T10:28:39Z Re: Set Analisys with a Null () function https://community.qlik.com/t5/QlikView/Set-Analisys-with-a-Null-function/m-p/652143#M238421 <HTML><HEAD></HEAD><BODY><P>try some thing like</P><P></P><P><STRONG>Sum(if(not isNull(OrderRequestDate)and OrderDate&gt;OrderRequestDate,NetWorkDays(OrderRequestDate,OrderDate)-1,0))/Count(OrderID)</STRONG></P></BODY></HTML> Fri, 17 Oct 2014 10:45:05 GMT https://community.qlik.com/t5/QlikView/Set-Analisys-with-a-Null-function/m-p/652143#M238421 sasikanth 2014-10-17T10:45:05Z Re: Set Analisys with a Null () function https://community.qlik.com/t5/QlikView/Set-Analisys-with-a-Null-function/m-p/652144#M238422 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>Set analysis to exclude null values (or actually include all non Null values) might be set as follows</P><P></P><P><STRONG>SUM({$&lt;OrderRequestDate = {*}&gt;} If(OrderDate&gt;OrderRequestDate, NetWorkDays(OrderRequestDate,OrderDate)-1,0))/Count(OrderID)</STRONG></P></BODY></HTML> Fri, 17 Oct 2014 10:50:51 GMT https://community.qlik.com/t5/QlikView/Set-Analisys-with-a-Null-function/m-p/652144#M238422 d_pranskus 2014-10-17T10:50:51Z