issue on number format

[chinnu123]

Hi community,

I created a double header in pivot table as per my requirement and now my issue is the number format for fields is not exact values they are in decimal format i need them in number format...

Example field ATT THE VALUE  is 100.042,709636 instead of 100,043

                          ADS   VALUE IS 1.152,778,40893 instead of 1,152,778

                           DDS     VALUE IS 0,0398500258516 instead of 4%    

I am attaching my qvw file can any one please look in to that and give me the solution how to resolve this

Thanks in advance

[robert_mika]

Change setting in script to

SET ThousandSep=',';

SET DecimalSep='.';

SET MoneyThousandSep=',';

SET MoneyDecimalSep='.';

SET MoneyFormat='€#,##0.00;-€#,##0.00';

[chinnu123]

Hi Robert,

Its not working

[Anonymous]

You just should change the number formats.

[chinnu123]

Hi Jannet,

please once see the my attached qvw i used double header format so its not possible in my case

Thanks in advance

[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.

[robert_mika]

qliviewwizard is right.

His solution works for me

Feeling Qlikngry?

How To /Missing Manual(18 articles)

[qlikviewwizard]

Hi Chinnu,

Did you able to resolve the issue?

[chinnu123]

No, its not working for me

[#10]

is this the correct format? (looks lik based on your description above)