topic Re: Decimal to Number format in QlikView

Decimal to Number format

chinnu123 — Mon, 14 Sep 2015 17:43:27 GMT

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

Re: Decimal to Number format

Oleg_Troyansky — Mon, 14 Sep 2015 17:46:48 GMT

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

Re: Decimal to Number format

sunny_talwar — Mon, 14 Sep 2015 17:48:01 GMT

May be this:

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

Re: Decimal to Number format

chinnu123 — Mon, 14 Sep 2015 18:06:40 GMT

Hi sunny,

The given script is not working fine

Regards,

Bhargav.

Re: Decimal to Number format

MarcoWedel — Mon, 14 Sep 2015 18:38:27 GMT

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

regards

Marco

Re: Decimal to Number format

Digvijay_Singh — Mon, 14 Sep 2015 18:45:44 GMT

Try like this -

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

replace constant with field value.

Re: Decimal to Number format

engishfaque — Tue, 15 Sep 2015 03:15:59 GMT

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

Re: Decimal to Number format

qlikviewwizard — Tue, 15 Sep 2015 03:41:02 GMT

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

Re: Decimal to Number format

qlikviewwizard — Wed, 16 Sep 2015 01:18:40 GMT

Hi Chinnu,

Did you able to resolve the issue?

Re: Decimal to Number format

chinnu123 — Wed, 16 Sep 2015 16:49:44 GMT

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

Re: Decimal to Number format

qlikviewwizard — Thu, 17 Sep 2015 01:15:13 GMT

Hi Chinnu,

Please check this file. If you still getting the same issue, attach your sample file.