topic How to filter data with a specific sentence in QlikView https://community.qlik.com/t5/QlikView/How-to-filter-data-with-a-specific-sentence/m-p/157589#M33007 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I would like to filter a group of companies in accord to the last sentence on its name.</P><P>Ex.</P><P>Field Data:</P><P>Brazil Shoes Inc.</P><P>Brazil Shoes Ltd.</P><P>What I want is to create a new group trough "Inc." and "Ltd."</P><P></P><P>Thanks,</P><P>Ronan</P><P></P><P></P></BODY></HTML> Mon, 25 Oct 2010 14:05:20 GMT 2010-10-25T14:05:20Z How to filter data with a specific sentence https://community.qlik.com/t5/QlikView/How-to-filter-data-with-a-specific-sentence/m-p/157589#M33007 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I would like to filter a group of companies in accord to the last sentence on its name.</P><P>Ex.</P><P>Field Data:</P><P>Brazil Shoes Inc.</P><P>Brazil Shoes Ltd.</P><P>What I want is to create a new group trough "Inc." and "Ltd."</P><P></P><P>Thanks,</P><P>Ronan</P><P></P><P></P></BODY></HTML> Mon, 25 Oct 2010 14:05:20 GMT https://community.qlik.com/t5/QlikView/How-to-filter-data-with-a-specific-sentence/m-p/157589#M33007 2010-10-25T14:05:20Z How to filter data with a specific sentence https://community.qlik.com/t5/QlikView/How-to-filter-data-with-a-specific-sentence/m-p/157590#M33008 <HTML><HEAD></HEAD><BODY><P>If i understood your question correct,</P><P>use</P><P style="margin:0in 0in 0pt;line-height:normal;mso-layout-grid-align:none;"><B>subfield</B>([<B>Brazil Shoes Inc.]</B>, ' ', 3) as Inc.,</P><P style="margin:0in 0in 0pt;line-height:normal;mso-layout-grid-align:none;"><STRONG>subfield</STRONG>([<B>Brazil Shoes Ltd.]</B>, ' ', 3) as Ltd.,</P><P style="margin:0in 0in 0pt;line-height:normal;mso-layout-grid-align:none;"></P><P style="margin:0in 0in 0pt;line-height:normal;mso-layout-grid-align:none;">Regards</P><P style="margin:0in 0in 0pt;line-height:normal;mso-layout-grid-align:none;">Ren</P></BODY></HTML> Mon, 25 Oct 2010 14:10:56 GMT https://community.qlik.com/t5/QlikView/How-to-filter-data-with-a-specific-sentence/m-p/157590#M33008 renjithpl 2010-10-25T14:10:56Z How to filter data with a specific sentence https://community.qlik.com/t5/QlikView/How-to-filter-data-with-a-specific-sentence/m-p/157591#M33009 <HTML><HEAD></HEAD><BODY><P>Ranjit</P><P>The thing is, I have several other companies under Ltd and Inc.</P><P>Does it works for everyone?</P><P>Thanks</P><P>Ronan</P></BODY></HTML> Mon, 25 Oct 2010 14:14:23 GMT https://community.qlik.com/t5/QlikView/How-to-filter-data-with-a-specific-sentence/m-p/157591#M33009 2010-10-25T14:14:23Z How to filter data with a specific sentence https://community.qlik.com/t5/QlikView/How-to-filter-data-with-a-specific-sentence/m-p/157592#M33010 <HTML><HEAD></HEAD><BODY><P>so instead of putting brazil ....</P><P>Try this</P><P></P><P style="margin:0in 0in 0pt;line-height:normal;mso-layout-grid-align:none;"><B>If(subfield</B>([your Field], ' ', 3) ='Inc.', 'Inc.', 'Ltd.') as XYZ,</P><P style="margin:0in 0in 0pt;line-height:normal;mso-layout-grid-align:none;"></P><P style="margin:0in 0in 0pt;line-height:normal;mso-layout-grid-align:none;">Your Field is nothing but the field has all the companies.</P><P style="margin:0in 0in 0pt;line-height:normal;mso-layout-grid-align:none;"></P><P style="margin:0in 0in 0pt;line-height:normal;mso-layout-grid-align:none;">then you can select XYZ to filter Inc or Ltd</P><P style="margin:0in 0in 0pt;line-height:normal;mso-layout-grid-align:none;"></P><P style="margin:0in 0in 0pt;line-height:normal;mso-layout-grid-align:none;">Regards</P><P style="margin:0in 0in 0pt;line-height:normal;mso-layout-grid-align:none;"></P><P style="margin:0in 0in 0pt;line-height:normal;mso-layout-grid-align:none;"></P><P style="margin:0in 0in 0pt;line-height:normal;mso-layout-grid-align:none;"></P><P style="margin:0in 0in 0pt;line-height:normal;mso-layout-grid-align:none;"></P></BODY></HTML> Mon, 25 Oct 2010 14:32:41 GMT https://community.qlik.com/t5/QlikView/How-to-filter-data-with-a-specific-sentence/m-p/157592#M33010 renjithpl 2010-10-25T14:32:41Z