Solved: Number format - Qlik Community

Mahamed_Qlik · ‎2016-04-26

Hi all,

How to convert the following amount into two decimal correct number format ?

suppose I have number as 153,050.00 (something like 1,53,050.00)

Regards,

mahamed

sunny_talwar · ‎2016-04-26

May be this:

SET ThousandSep=',';

SET DecimalSep='.';

SET MoneyThousandSep='.';

//SET MoneyDecimalSep=',';

SET MoneyDecimalSep='.';

SET MoneyFormat='€ #.##0,00;€ -#.##0,00';

SET TimeFormat='h:mm:ss';

SET DateFormat='DD-MM-YYYY';

SET TimestampFormat='DD-MM-YYYY h:mm:ss[.fff]';

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

SET DayNames='Mo;Tu;We;Th;Fr;Sa;Su';

SET HidePrefix = '_';

Table:

LOAD *,

Num(GBPRateAmount, '#,##,##,##,##,##,###.##') as NewField;

LOAD * Inline [

GBPRateAmount

153.20

14.364

1123.645

246200.9687

];

View solution in original post

PrashantSangle · ‎2016-04-26

Hi,

Use num(FieldName,'#,##,#00.00')

Kind Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

sunny_talwar · ‎2016-04-26

May be try this:

=Num(Num#('153,050.00', '#,##0.00'), '#,##,##0.00')

or just this for a numeric field

=Num(FieldName, '#,##,##0.00')

MK_QSL · ‎2016-04-26

=Num('153,050.00','#,##,##0.##', '.' , ',' )

amit_saini · ‎2016-04-26

hi,

Try this:

=num(your_Field, '#,##,##0.00')

or

Thanks,

AS

swuehl · ‎2016-04-26

I don't understand your request.

In what sense is this a correct number format:

1,53,050.00

What is the rule behind using the thousand separator differently?

sunny_talwar · ‎2016-04-26

Stefan -

In India (and may be other parts of the world) we do use a different version of comma separators

For example:

10,00,00,000

Indian numbering system - Wikipedia, the free encyclopedia

PrashantSangle · ‎2016-04-26

Hi,

In Asia People use this kind of format.

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

ThornOfCrowns · ‎2016-04-26

That was an interesting read, thanks for the link!

swuehl · ‎2016-04-26

Sunny, thank you for the link, I didn't know this indeed.

But I think we would need to give a full length format code then (e.g. assuming max 14 digits :

=Num(YourExpression, '#,##,##,##,##,##,##0','.',',')

Number format

Related Topics