Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

OmarBenSalem
Esteemed Contributor

Number format

Hi folks,

I'm trying to format my numbers in the SCRIPT.

here's how they're now:

Capture.PNG

and I want them to be as follow:

Capture.PNG

For that, I've done as follow:

num(Current_Notional,'# ##0') as Current_Notional,


and

num(num#(Current_Notional),'# ##0') as Current_Notional,

But, this did not change a thing !

What am I doing wrong?

1 Solution

Accepted Solutions
Chanty4u
Esteemed Contributor III

Re: Number format

try this

Num#( Field, '#', ' ', ' ') as Result

15 Replies
Chanty4u
Esteemed Contributor III

Re: Number format

do you want round the values?

result is different than actual?

OmarBenSalem
Esteemed Contributor

Re: Number format

Ah ; it's not the same cells / values! It's just an example of the format I want to achieve..

sorry for the confusion !

Chanty4u
Esteemed Contributor III

Re: Number format

try this

Num#( Field, '#', ' ', ' ') as Result

mdmukramali
Valued Contributor II

Re: Number format

Hi Omar,

Can you Try something like this:

Load *,

PurgeChar(Number,',') as Test,

Num(PurgeChar(Number,','),'# ##0','.',' ') as Test2

inline

[

Number

"5575226851,9277"

"5017367203,3098"

]

Thanks,

Mukram.

Chanty4u
Esteemed Contributor III

Re: Number format

or try this

a:load  * Inline [

Categ ,Year,Sales

Car,2014,"100677884,122"

];

result:

LOAD *

,

replace(Sales,',',' ') as new

Resident a;

OmarBenSalem
Esteemed Contributor

Re: Number format

This did not work

OmarBenSalem
Esteemed Contributor

Re: Number format

That was perfect !

OmarBenSalem
Esteemed Contributor

Re: Number format

This nearly worked when there is number as follow 444,22 (with ',') but with numbers without , exp: 44444; it did not !

Thank you anyway !

Capture.PNG

Chanty4u
Esteemed Contributor III

Re: Number format

Nice your issue resolved .

Community Browser