Decimal to Number format

[chinnu123]

Hi community I have a one question regarding number format.Actually i have a field called july in that i am getting values like 4912897,0381758 but i need to get 4,912,897.And one more thing i have no chance to use that field in expression so there is no possible to change in presentation. i have only chance to write in script so any one can help please

[Oleg_Troyansky]

Open Document Properties > Number, and define the desired format for the numeric field.

that should solve the problem.

cheers,

Oleg Troyansky

QlikView Your Business: An expert guide to Business Discovery with QlikView and Qlik Sense

[sunny_talwar]

May be this:

Num(Num#(SubField(Field, ',', 1), '##'), '#,##0') as Field

[chinnu123]

Hi sunny,

The given script is not working fine

Regards,

Bhargav.

[MarcoWedel]

‌Maybe you could post a sample app to demonstrate the issue?

regards

Marco

[Digvijay_Singh]

Try like this -

=Num(Num#(4912897,'###0'),'#,##0')

replace constant with field value.

[engishfaque]

Dear Chinnu,

Here it's,

Temp:

LOAD * Inline [

  YourFieldValue

  4912897

  0381758

];

=Num(YourFieldValue, '#,##0')

A sample file is  also attached with this post, kindly find attached document.

Kind regards,

Ishfaque Ahmed

[qlikviewwizard]

Hi,

Please check this.

Reason for this issue is- thousand separator should be comma instead of dot,decimal should be dot instead of comma.

Hope this will help.

issue on number format

[qlikviewwizard]

Hi Chinnu,

Did you able to resolve the issue?

[chinnu123]

No, I am not getting exact values I am getting zeros in % field