LogicHelp

[abhaysingh]

Hi guys,

I have one field in which values are

Field1

000234

.345

2356

9876

000012

Field 2

234

.345

2356

9876

12

Required Output

234

.345

2356

9876

12

Pls help

Regards

Abhay

[pokassov]

Evaluate?

[Peter_Cammaert]

Load all fields with

num(num#(DataField), '#.###', '.')

[#4]

Finally the output is field2?

[Kushal_Chawda]

Simply do num(Field1)

or

purgechar(Field1,'0')

[ashwanin]

i think this is what you required.

[ganeshreddy]

Hi Abhay,

I think you need to apply purgechar logic which Kush has mentioned above. for reference go through attached file.

Cheers,

Ganesh

[qlikviewwizard]

Hi Abhay, did you able to manage to get the solution, please? Thank you.