topic Re: need help in QlikView https://community.qlik.com/t5/QlikView/need-help/m-p/77389#M778454 <HTML><HEAD></HEAD><BODY><P>use below in script</P><P><BR />SubField(YourFieldName,'.',1) as YourNewField</P></BODY></HTML> Mon, 23 Apr 2018 09:10:53 GMT MK_QSL 2018-04-23T09:10:53Z need help https://community.qlik.com/t5/QlikView/need-help/m-p/77388#M778453 <HTML><HEAD></HEAD><BODY><P> i need to show before dot word(only first dot before data)</P><P>how</P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/200508_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/need-help/m-p/77388#M778453 qlikapple 2020-11-25T16:16:04Z Re: need help https://community.qlik.com/t5/QlikView/need-help/m-p/77389#M778454 <HTML><HEAD></HEAD><BODY><P>use below in script</P><P><BR />SubField(YourFieldName,'.',1) as YourNewField</P></BODY></HTML> Mon, 23 Apr 2018 09:10:53 GMT https://community.qlik.com/t5/QlikView/need-help/m-p/77389#M778454 MK_QSL 2018-04-23T09:10:53Z Re: need help https://community.qlik.com/t5/QlikView/need-help/m-p/77390#M778455 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P>load SubField(A,'.',1) as F</P></BODY></HTML> Mon, 23 Apr 2018 10:13:48 GMT https://community.qlik.com/t5/QlikView/need-help/m-p/77390#M778455 shiveshsingh 2018-04-23T10:13:48Z