Discussion board where members can get started with Qlik Sense.
I'm trying to format my numbers in the SCRIPT.
here's how they're now:
and I want them to be as follow:
For that, I've done as follow:
num(Current_Notional,'# ##0') as Current_Notional,
num(num#(Current_Notional),'# ##0') as Current_Notional,
But, this did not change a thing !
What am I doing wrong?
Go to Solution.
Num#( Field, '#', ' ', ' ') as Result
do you want round the values?
result is different than actual?
Ah ; it's not the same cells / values! It's just an example of the format I want to achieve..
sorry for the confusion !
Can you Try something like this:
PurgeChar(Number,',') as Test,
Num(PurgeChar(Number,','),'# ##0','.',' ') as Test2
or try this
a:load * Inline [
replace(Sales,',',' ') as new
This did not work
That was perfect !
This nearly worked when there is number as follow 444,22 (with ',') but with numbers without , exp: 44444; it did not !
Thank you anyway !
Nice your issue resolved .