topic Re: question about my expression formatting in QlikView https://community.qlik.com/t5/QlikView/question-about-my-expression-formatting/m-p/390741#M486898 <HTML><HEAD></HEAD><BODY><P>Also, in the match(), your 3rd argument is quoted as if you are specifying a string, but you also surround with braces as you would a field.&nbsp; I don't know your data or intent, but that looks a bit odd.</P></BODY></HTML> Thu, 28 Feb 2013 02:22:24 GMT 2013-02-28T02:22:24Z question about my expression formatting https://community.qlik.com/t5/QlikView/question-about-my-expression-formatting/m-p/390738#M486895 <HTML><HEAD></HEAD><BODY><P>You guys see anything wrong with this? It's returning no data to display.</P><P></P><P>sum(if(APEL_LTR_SNT_DT-[Received Date] &lt;= (if(APEL_EXTN_IN = 'N' or isNull(APEL_EXTN_IN), 30,44)) and match(DSFT_SEVY_DS, 'Standard60', '[Moved to Standard30]') and [Medicare Type]= 'C'),1))</P><P></P><P>I'm wondering if I'm doing the "isNull" wrong? </P><P></P><P>Maybe it's my entire if, where I'm returning either 30 or 44?</P></BODY></HTML> Wed, 27 Feb 2013 19:05:46 GMT https://community.qlik.com/t5/QlikView/question-about-my-expression-formatting/m-p/390738#M486895 2013-02-27T19:05:46Z Re: question about my expression formatting https://community.qlik.com/t5/QlikView/question-about-my-expression-formatting/m-p/390739#M486896 <HTML><HEAD></HEAD><BODY><P>isnull is fine, is the value actually null? are you sure it's not blank ('') or something else?</P></BODY></HTML> Thu, 28 Feb 2013 02:06:22 GMT https://community.qlik.com/t5/QlikView/question-about-my-expression-formatting/m-p/390739#M486896 danielrozental 2013-02-28T02:06:22Z Re: question about my expression formatting https://community.qlik.com/t5/QlikView/question-about-my-expression-formatting/m-p/390740#M486897 <HTML><HEAD></HEAD><BODY><P>Your parens are not matching there... maybe you missed a left paren just before match.</P></BODY></HTML> Thu, 28 Feb 2013 02:17:37 GMT https://community.qlik.com/t5/QlikView/question-about-my-expression-formatting/m-p/390740#M486897 2013-02-28T02:17:37Z Re: question about my expression formatting https://community.qlik.com/t5/QlikView/question-about-my-expression-formatting/m-p/390741#M486898 <HTML><HEAD></HEAD><BODY><P>Also, in the match(), your 3rd argument is quoted as if you are specifying a string, but you also surround with braces as you would a field.&nbsp; I don't know your data or intent, but that looks a bit odd.</P></BODY></HTML> Thu, 28 Feb 2013 02:22:24 GMT https://community.qlik.com/t5/QlikView/question-about-my-expression-formatting/m-p/390741#M486898 2013-02-28T02:22:24Z