topic Re: substring in QlikView https://community.qlik.com/t5/QlikView/substring/m-p/1343265#M413594 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Do you have this value in your table ? then you can use filter condition.</P><P></P><P>Please share some sample files for better understanding</P></BODY></HTML> Thu, 22 Jun 2017 11:58:55 GMT Anonymous 2017-06-22T11:58:55Z substring https://community.qlik.com/t5/QlikView/substring/m-p/1343262#M413591 <HTML><HEAD></HEAD><BODY><P>Hi all</P><P>&nbsp; I have text file.substring values are</P><P>file1 india,hyd pune</P><P>file1 india,hyd,chennai</P><P>i want to display only pune chennai.how can i do this?</P></BODY></HTML> Thu, 22 Jun 2017 11:22:55 GMT https://community.qlik.com/t5/QlikView/substring/m-p/1343262#M413591 2017-06-22T11:22:55Z Re: substring https://community.qlik.com/t5/QlikView/substring/m-p/1343263#M413592 <HTML><HEAD></HEAD><BODY><P>Why you want to use substring here&nbsp; you have other way to do it.</P><P></P><P>Please share some sample data with expected output.</P></BODY></HTML> Thu, 22 Jun 2017 11:34:24 GMT https://community.qlik.com/t5/QlikView/substring/m-p/1343263#M413592 prma7799 2017-06-22T11:34:24Z Re: substring https://community.qlik.com/t5/QlikView/substring/m-p/1343264#M413593 <HTML><HEAD></HEAD><BODY><P>May be use?</P><P><STRONG>If(Match(file1, 'pune','chennai'), file1)</STRONG></P></BODY></HTML> Thu, 22 Jun 2017 11:58:33 GMT https://community.qlik.com/t5/QlikView/substring/m-p/1343264#M413593 Anil_Babu_Samineni 2017-06-22T11:58:33Z Re: substring https://community.qlik.com/t5/QlikView/substring/m-p/1343265#M413594 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Do you have this value in your table ? then you can use filter condition.</P><P></P><P>Please share some sample files for better understanding</P></BODY></HTML> Thu, 22 Jun 2017 11:58:55 GMT https://community.qlik.com/t5/QlikView/substring/m-p/1343265#M413594 Anonymous 2017-06-22T11:58:55Z