topic Re: Num Formatting in QlikView

Num Formatting

mario-sarkis — Wed, 25 Nov 2020 16:16:04 GMT

Dear ALL,

I need to transform an number '002' to 2

I have a field Branch code looks like '002' or '014' or '051' I need to transform it as 2,14,51

I tired num([Branch Code]) & num#([Branch Code]) it didn't work it still giving me '002' or '014' or '051'

hope that you can help with this I need to transform the above field in the script.

thank you,

sunny_talwar — Thu, 29 Mar 2018 16:13:58 GMT

Can you try this

[Branch Code] * 1 as [Branch Code]

m_woolf — Thu, 29 Mar 2018 16:15:05 GMT

num# should work. Does your field have any leading or trailing spaces? Maybe:

num#(trim([Branch Code]))

sunny_talwar — Thu, 29 Mar 2018 16:21:32 GMT

May be a over-arching Num() is needed after Num#()

Num(Num#([Branch Code]))

Because Num#() only helps to interpret, but the change will need Num(), right?