topic Re: Match Clause in QlikView https://community.qlik.com/t5/QlikView/Match-Clause/m-p/1244194#M854511 <HTML><HEAD></HEAD><BODY><P>I don't think your MATCH format is correct.</P><P>It should be along the lines of: <STRONG><SPAN class="Code">match( M, 'Jan','Feb','Mar')</SPAN> </STRONG></P><P></P><P>See the help for fuller details.</P></BODY></HTML> Thu, 09 Feb 2017 16:53:11 GMT richard_chilvers 2017-02-09T16:53:11Z Match Clause https://community.qlik.com/t5/QlikView/Match-Clause/m-p/1244192#M854509 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have the following formula, please advise where I am going wrong:</P><P>=If (MATCH (Closed_Date = " "),'Closed Cases','Open Cases')</P><P>I need all blanks in the column to be shown a s a Closed Cases in a list box and all dates to be shown as Open Cases.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Match-Clause/m-p/1244192#M854509 2020-11-25T16:16:04Z Re: Match Clause https://community.qlik.com/t5/QlikView/Match-Clause/m-p/1244193#M854510 <HTML><HEAD></HEAD><BODY><P>May be try this:</P><P></P><P><STRONG>=If(Len(Trim(Closed_Date)) = 0, 'Closed Cases', 'Open Cases')</STRONG></P></BODY></HTML> Thu, 09 Feb 2017 16:42:52 GMT https://community.qlik.com/t5/QlikView/Match-Clause/m-p/1244193#M854510 sunny_talwar 2017-02-09T16:42:52Z Re: Match Clause https://community.qlik.com/t5/QlikView/Match-Clause/m-p/1244194#M854511 <HTML><HEAD></HEAD><BODY><P>I don't think your MATCH format is correct.</P><P>It should be along the lines of: <STRONG><SPAN class="Code">match( M, 'Jan','Feb','Mar')</SPAN> </STRONG></P><P></P><P>See the help for fuller details.</P></BODY></HTML> Thu, 09 Feb 2017 16:53:11 GMT https://community.qlik.com/t5/QlikView/Match-Clause/m-p/1244194#M854511 richard_chilvers 2017-02-09T16:53:11Z Re: Match Clause https://community.qlik.com/t5/QlikView/Match-Clause/m-p/1244195#M854512 <HTML><HEAD></HEAD><BODY><P>Hi Yolanda,</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">can u better explain what you're try to get?</P></BODY></HTML> Thu, 09 Feb 2017 17:04:43 GMT https://community.qlik.com/t5/QlikView/Match-Clause/m-p/1244195#M854512 19iv1987 2017-02-09T17:04:43Z