topic issue in QlikView https://community.qlik.com/t5/QlikView/issue/m-p/55503#M781764 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P>I have a column (TYPE) contains below</P><P>&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" jive-data-cell="{&quot;color&quot;:&quot;#575757&quot;,&quot;textAlign&quot;:&quot;left&quot;,&quot;padding&quot;:&quot;NaN&quot;,&quot;backgroundColor&quot;:&quot;transparent&quot;,&quot;fontFamily&quot;:&quot;arial,helvetica,sans-serif&quot;,&quot;verticalAlign&quot;:&quot;baseline&quot;}" jive-data-header="{&quot;color&quot;:&quot;#FFFFFF&quot;,&quot;backgroundColor&quot;:&quot;#6690BC&quot;,&quot;textAlign&quot;:&quot;center&quot;,&quot;padding&quot;:&quot;2&quot;}" style="width: 64px;"><TBODY><TR><TH style="color: #ffffff; background-color: #6690bc; text-align: center; padding: 2px;">TYPE</TH></TR><TR><TD height="20" style="color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">Other</TD></TR><TR><TD height="20" style="color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">Others</TD></TR><TR><TD height="20" style="color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">missing</TD></TR><TR><TD height="20" style="color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">customs</TD></TR></TBODY></TABLE><P></P><P>Here i want to display instead of Others need to show Other and remaining fields.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT vinod2086 2020-11-25T16:16:04Z issue https://community.qlik.com/t5/QlikView/issue/m-p/55503#M781764 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P>I have a column (TYPE) contains below</P><P>&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" jive-data-cell="{&quot;color&quot;:&quot;#575757&quot;,&quot;textAlign&quot;:&quot;left&quot;,&quot;padding&quot;:&quot;NaN&quot;,&quot;backgroundColor&quot;:&quot;transparent&quot;,&quot;fontFamily&quot;:&quot;arial,helvetica,sans-serif&quot;,&quot;verticalAlign&quot;:&quot;baseline&quot;}" jive-data-header="{&quot;color&quot;:&quot;#FFFFFF&quot;,&quot;backgroundColor&quot;:&quot;#6690BC&quot;,&quot;textAlign&quot;:&quot;center&quot;,&quot;padding&quot;:&quot;2&quot;}" style="width: 64px;"><TBODY><TR><TH style="color: #ffffff; background-color: #6690bc; text-align: center; padding: 2px;">TYPE</TH></TR><TR><TD height="20" style="color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">Other</TD></TR><TR><TD height="20" style="color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">Others</TD></TR><TR><TD height="20" style="color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">missing</TD></TR><TR><TD height="20" style="color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">customs</TD></TR></TBODY></TABLE><P></P><P>Here i want to display instead of Others need to show Other and remaining fields.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/issue/m-p/55503#M781764 vinod2086 2020-11-25T16:16:04Z Re: issue https://community.qlik.com/t5/QlikView/issue/m-p/55504#M781765 <HTML><HEAD></HEAD><BODY><P>Try like</P><P></P><P>LOAD Col1, col2, IF(NOT Match(TYPE, 'Others'), TYPE) AS TYPE</P><P>FROM yoursourcetablename; </P></BODY></HTML> Wed, 04 Apr 2018 14:45:57 GMT https://community.qlik.com/t5/QlikView/issue/m-p/55504#M781765 vishsaggi 2018-04-04T14:45:57Z Re: issue https://community.qlik.com/t5/QlikView/issue/m-p/55505#M781766 <HTML><HEAD></HEAD><BODY><P>Try This,</P><P>Load *, IF(Match(TYPE, 'Others'), 'Other', TYPE) as NEWTYPE;</P><P>Load * Inline [</P><P>TYPE</P><P>Other</P><P>Others</P><P>missing</P><P>customs</P><P>];</P></BODY></HTML> Wed, 04 Apr 2018 17:14:40 GMT https://community.qlik.com/t5/QlikView/issue/m-p/55505#M781766 Nagaraju_KCS 2018-04-04T17:14:40Z Re: issue https://community.qlik.com/t5/QlikView/issue/m-p/55506#M781767 <HTML><HEAD></HEAD><BODY><P>if(Match(TYPE,'<SPAN style="font-size: 13px;">Others'), 'Other', TYPE) as your field</SPAN></P><P><SPAN style="font-size: 13px;"><BR /></SPAN></P><P><SPAN style="font-size: 13px;">resident previousTable..</SPAN></P></BODY></HTML> Wed, 04 Apr 2018 17:18:38 GMT https://community.qlik.com/t5/QlikView/issue/m-p/55506#M781767 shiveshsingh 2018-04-04T17:18:38Z