topic Re: LogicHelp in QlikView https://community.qlik.com/t5/QlikView/LogicHelp/m-p/945046#M981854 <HTML><HEAD></HEAD><BODY><P>Hi Abhay, did you able to manage to get the solution, please? Thank you.</P></BODY></HTML> Tue, 18 Aug 2015 14:29:44 GMT qlikviewwizard 2015-08-18T14:29:44Z LogicHelp https://community.qlik.com/t5/QlikView/LogicHelp/m-p/945039#M981847 <HTML><HEAD></HEAD><BODY><P>Hi guys,</P><P></P><P>I have one field in which values are</P><P>Field1</P><P>000234</P><P>.345</P><P>2356</P><P>9876</P><P>000012</P><P></P><P>Field 2</P><P> 234</P><P>.345</P><P>2356</P><P>9876</P><P> 12</P><P></P><P>Required Output</P><P> 234</P><P>.345</P><P>2356</P><P>9876</P><P> 12</P><P></P><P>Pls help</P><P>Regards</P><P>Abhay</P></BODY></HTML> Tue, 18 Aug 2015 10:45:00 GMT https://community.qlik.com/t5/QlikView/LogicHelp/m-p/945039#M981847 abhaysingh 2015-08-18T10:45:00Z Re: LogicHelp https://community.qlik.com/t5/QlikView/LogicHelp/m-p/945040#M981848 <HTML><HEAD></HEAD><BODY><P>Evaluate?</P></BODY></HTML> Tue, 18 Aug 2015 10:46:05 GMT https://community.qlik.com/t5/QlikView/LogicHelp/m-p/945040#M981848 pokassov 2015-08-18T10:46:05Z Re: LogicHelp https://community.qlik.com/t5/QlikView/LogicHelp/m-p/945041#M981849 <HTML><HEAD></HEAD><BODY><P>Load all fields with </P><P></P><P>num(num#(DataField), '#.###', '.')</P></BODY></HTML> Tue, 18 Aug 2015 10:48:30 GMT https://community.qlik.com/t5/QlikView/LogicHelp/m-p/945041#M981849 Peter_Cammaert 2015-08-18T10:48:30Z Re: LogicHelp https://community.qlik.com/t5/QlikView/LogicHelp/m-p/945042#M981850 <HTML><HEAD></HEAD><BODY><P>Finally the output is field2?</P></BODY></HTML> Tue, 18 Aug 2015 10:52:55 GMT https://community.qlik.com/t5/QlikView/LogicHelp/m-p/945042#M981850 2015-08-18T10:52:55Z Re: LogicHelp https://community.qlik.com/t5/QlikView/LogicHelp/m-p/945043#M981851 <HTML><HEAD></HEAD><BODY><P>Simply do <STRONG> num(Field1)</STRONG></P><P></P><P>or</P><P></P><P><STRONG style="font-size: 13.3333330154419px;">purgechar(Field1,'0')</STRONG></P></BODY></HTML> Tue, 18 Aug 2015 10:58:26 GMT https://community.qlik.com/t5/QlikView/LogicHelp/m-p/945043#M981851 Kushal_Chawda 2015-08-18T10:58:26Z Re: LogicHelp https://community.qlik.com/t5/QlikView/LogicHelp/m-p/945044#M981852 <HTML><HEAD></HEAD><BODY><P>i think this is what you required. </P></BODY></HTML> Tue, 18 Aug 2015 11:07:12 GMT https://community.qlik.com/t5/QlikView/LogicHelp/m-p/945044#M981852 ashwanin 2015-08-18T11:07:12Z Re: LogicHelp https://community.qlik.com/t5/QlikView/LogicHelp/m-p/945045#M981853 <HTML><HEAD></HEAD><BODY><P>Hi Abhay,</P><P></P><P>I think you need to apply purgechar logic which Kush has mentioned above. for reference go through attached file.</P><P></P><P>Cheers,</P><P>Ganesh</P></BODY></HTML> Tue, 18 Aug 2015 11:46:16 GMT https://community.qlik.com/t5/QlikView/LogicHelp/m-p/945045#M981853 ganeshreddy 2015-08-18T11:46:16Z Re: LogicHelp https://community.qlik.com/t5/QlikView/LogicHelp/m-p/945046#M981854 <HTML><HEAD></HEAD><BODY><P>Hi Abhay, did you able to manage to get the solution, please? Thank you.</P></BODY></HTML> Tue, 18 Aug 2015 14:29:44 GMT https://community.qlik.com/t5/QlikView/LogicHelp/m-p/945046#M981854 qlikviewwizard 2015-08-18T14:29:44Z