topic Re: functions in QlikView

functions

rathnam_qv — Thu, 24 Oct 2013 07:02:00 GMT

Hi all,

i hv ABC field which has values like 0001.00,0002.00

but i want to remove decimal from that number like 000100,000200

can any one help

Thanks in advance!!!!

Smiley

tresB — Thu, 24 Oct 2013 07:16:51 GMT

Use PurgeChar() like:

=PurgeChar('0001.00,0002.00', '.')

Or,

Load

PurgeChar(YourField, '.') as NewField

Thu, 24 Oct 2013 07:19:43 GMT

Try This

Replace(fieldname,'.','') as Fieldname

if you need any thing more please find the attachment