topic Re: Data source have differnt ailment in QlikView https://community.qlik.com/t5/QlikView/Data-source-have-differnt-ailment/m-p/385796#M565932 <HTML><HEAD></HEAD><BODY><P>thank for uer reply</P><P></P><P></P><P> i&nbsp; am getting like&nbsp; th is if i use</P><P>&nbsp; 100</P><P>&nbsp; 200</P><P>&nbsp; 300</P><P>&nbsp; 400</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 500</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 600</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 700</P></BODY></HTML> Wed, 02 Jan 2013 08:38:37 GMT 2013-01-02T08:38:37Z Data source have differnt ailment https://community.qlik.com/t5/QlikView/Data-source-have-differnt-ailment/m-p/385792#M565928 <HTML><HEAD></HEAD><BODY><P>Dear all</P><P></P><P></P><P> i am loading data&nbsp; from qvd&nbsp; to&nbsp; qlikview</P><P></P><P>my one filed&nbsp;&nbsp; XYZ</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100 </P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 200</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 300</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 400</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 500</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 600</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 700</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 800</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 900</P><P></P><P>i need&nbsp;&nbsp; XYZ</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 200</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 300</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 400</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 500</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 600</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 700</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 800</P></BODY></HTML> Wed, 02 Jan 2013 08:15:21 GMT https://community.qlik.com/t5/QlikView/Data-source-have-differnt-ailment/m-p/385792#M565928 2013-01-02T08:15:21Z Re: Data source have differnt ailment https://community.qlik.com/t5/QlikView/Data-source-have-differnt-ailment/m-p/385793#M565929 <HTML><HEAD></HEAD><BODY><P>Hi surik147,</P><P></P><P>If's because there are leading spaces in the field, you can use the TRIM functions to remoce them.</P><P>=ltrim(XYZ)</P></BODY></HTML> Wed, 02 Jan 2013 08:21:20 GMT https://community.qlik.com/t5/QlikView/Data-source-have-differnt-ailment/m-p/385793#M565929 jfkinspari 2013-01-02T08:21:20Z Re: Data source have differnt ailment https://community.qlik.com/t5/QlikView/Data-source-have-differnt-ailment/m-p/385794#M565930 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Num(LTrim(XYZ)) as XYZ; If u have all Numbers.</P><P></P><P></P><P>Regards,</P><P>Khadeer</P></BODY></HTML> Wed, 02 Jan 2013 08:21:27 GMT https://community.qlik.com/t5/QlikView/Data-source-have-differnt-ailment/m-p/385794#M565930 khadeer 2013-01-02T08:21:27Z Re: Data source have differnt ailment https://community.qlik.com/t5/QlikView/Data-source-have-differnt-ailment/m-p/385795#M565931 <HTML><HEAD></HEAD><BODY><P>thank for uer reply</P><P></P><P></P><P> i&nbsp; am getting like&nbsp; th is if i use</P><P>&nbsp; 100</P><P>&nbsp; 200</P><P>&nbsp; 300</P><P>&nbsp; 400</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 500</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 600</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 700</P></BODY></HTML> Wed, 02 Jan 2013 08:38:31 GMT https://community.qlik.com/t5/QlikView/Data-source-have-differnt-ailment/m-p/385795#M565931 2013-01-02T08:38:31Z Re: Data source have differnt ailment https://community.qlik.com/t5/QlikView/Data-source-have-differnt-ailment/m-p/385796#M565932 <HTML><HEAD></HEAD><BODY><P>thank for uer reply</P><P></P><P></P><P> i&nbsp; am getting like&nbsp; th is if i use</P><P>&nbsp; 100</P><P>&nbsp; 200</P><P>&nbsp; 300</P><P>&nbsp; 400</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 500</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 600</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 700</P></BODY></HTML> Wed, 02 Jan 2013 08:38:37 GMT https://community.qlik.com/t5/QlikView/Data-source-have-differnt-ailment/m-p/385796#M565932 2013-01-02T08:38:37Z Re: Data source have differnt ailment https://community.qlik.com/t5/QlikView/Data-source-have-differnt-ailment/m-p/385797#M565933 <HTML><HEAD></HEAD><BODY><P>use </P><P></P><P>Num(trim(XYZ))</P><P></P><P>Hope this helps</P></BODY></HTML> Wed, 02 Jan 2013 09:11:54 GMT https://community.qlik.com/t5/QlikView/Data-source-have-differnt-ailment/m-p/385797#M565933 SunilChauhan 2013-01-02T09:11:54Z Re: Data source have differnt ailment https://community.qlik.com/t5/QlikView/Data-source-have-differnt-ailment/m-p/385798#M565934 <HTML><HEAD></HEAD><BODY><P>thank for uer&nbsp; reply</P><P></P><P></P><P>xyz&nbsp; like&nbsp; 300,33H,123 </P></BODY></HTML> Wed, 02 Jan 2013 09:41:59 GMT https://community.qlik.com/t5/QlikView/Data-source-have-differnt-ailment/m-p/385798#M565934 2013-01-02T09:41:59Z Re: Data source have differnt ailment https://community.qlik.com/t5/QlikView/Data-source-have-differnt-ailment/m-p/385799#M565935 <HTML><HEAD></HEAD><BODY><P>hi</P><P></P><P> try like this</P><P></P><P>trim(subfield(xyz,','))</P><P></P><P>hpe it helps</P></BODY></HTML> Thu, 03 Jan 2013 00:54:18 GMT https://community.qlik.com/t5/QlikView/Data-source-have-differnt-ailment/m-p/385799#M565935 MayilVahanan 2013-01-03T00:54:18Z