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

[#2]

I just noticee that one field you wanted as a percent

the sample attached was accomplished by using chart properties as mentioned above.  since all of your data is not in the same format but is represented via a single express, that may not be the ultimate solution.

You may need to sue an If function in your expression to format based on field

[#3]

Hi,

i expect qlick does not intepret these values as numbers.

Firstly use setting

SET ThousandSep=',';

SET DecimalSep='.';

SET MoneyThousandSep=',';

SET MoneyDecimalSep='.';

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

as Robert Mika mentioned above.

Then loading data from data source change values to numbers using :

num#(replace(replace(  Field , '.' , '' ), ','   , '.' ))

Then you will be able to format data any way you like.

[qlikviewwizard]

Hi Chinnu,

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

[chinnu123]

Hi qlikviewwizard,

  Thanks for showing more interest on resolving my issue..

  I am attaching my excel sheet which is the exact values that i want to represent exact values in qlik once please have a look

[qlikviewwizard]

Hi Chinnu,

Please check the attached file.

Reason for this issue is number format.

Existing Value separater - Decimal is comma, thousands is dot.

I have changed the value separater - Decimal is dot, thousands is comma for all the numbers. Even Percentage too.

Hope this will help you.

Please select Correct and Helpful Answers to close the thread.