topic extract in QlikView https://community.qlik.com/t5/QlikView/extract/m-p/1249246#M395632 <HTML><HEAD></HEAD><BODY><P>Hello Guys,</P><P><SPAN style="color: #545454; font-family: arial, sans-serif; font-size: small;">Which </SPAN><SPAN style="font-weight: bold; color: #6a6a6a; font-family: arial, sans-serif; font-size: small;">Function</SPAN> in qlikview that allow me to extract a number from the 4th number and get 8 numbers</P><P></P><P>for example :</P><P></P><P>223698574</P><P>the result : <SPAN style="font-size: 13.3333px;">698574</SPAN></P><P></P><P>Thanks</P></BODY></HTML> Wed, 08 Mar 2017 10:29:12 GMT master_student 2017-03-08T10:29:12Z extract https://community.qlik.com/t5/QlikView/extract/m-p/1249246#M395632 <HTML><HEAD></HEAD><BODY><P>Hello Guys,</P><P><SPAN style="color: #545454; font-family: arial, sans-serif; font-size: small;">Which </SPAN><SPAN style="font-weight: bold; color: #6a6a6a; font-family: arial, sans-serif; font-size: small;">Function</SPAN> in qlikview that allow me to extract a number from the 4th number and get 8 numbers</P><P></P><P>for example :</P><P></P><P>223698574</P><P>the result : <SPAN style="font-size: 13.3333px;">698574</SPAN></P><P></P><P>Thanks</P></BODY></HTML> Wed, 08 Mar 2017 10:29:12 GMT https://community.qlik.com/t5/QlikView/extract/m-p/1249246#M395632 master_student 2017-03-08T10:29:12Z Re: extract https://community.qlik.com/t5/QlikView/extract/m-p/1249247#M395633 <HTML><HEAD></HEAD><BODY><P>use mid()</P><P></P><P>Regards,</P><P>Prashant</P></BODY></HTML> Wed, 08 Mar 2017 10:31:49 GMT https://community.qlik.com/t5/QlikView/extract/m-p/1249247#M395633 PrashantSangle 2017-03-08T10:31:49Z Re: extract https://community.qlik.com/t5/QlikView/extract/m-p/1249248#M395634 <HTML><HEAD></HEAD><BODY><P>May be this?</P><P></P><P><STRONG>Mid(FieldName, 4,8) </STRONG></P></BODY></HTML> Wed, 08 Mar 2017 10:32:37 GMT https://community.qlik.com/t5/QlikView/extract/m-p/1249248#M395634 Anil_Babu_Samineni 2017-03-08T10:32:37Z Re: extract https://community.qlik.com/t5/QlikView/extract/m-p/1249249#M395635 <HTML><HEAD></HEAD><BODY><P>Hi </P><P></P><P>Mid (Field, 4, <span class="lia-unicode-emoji" title=":smiling_face_with_sunglasses:">😎</span> as NewField</P><P></P><P>Regards</P></BODY></HTML> Wed, 08 Mar 2017 10:32:50 GMT https://community.qlik.com/t5/QlikView/extract/m-p/1249249#M395635 2017-03-08T10:32:50Z Re: extract https://community.qlik.com/t5/QlikView/extract/m-p/1249250#M395636 <HTML><HEAD></HEAD><BODY><P>Hi WIEM,</P><P></P><P>Might this help you : =Mid('223698574',4)</P><P>as per you requirement you said</P><P></P><P>Regards,</P><P>Nitin.</P></BODY></HTML> Wed, 08 Mar 2017 10:35:34 GMT https://community.qlik.com/t5/QlikView/extract/m-p/1249250#M395636 nitin_01 2017-03-08T10:35:34Z