Round off value incorrect

[#1]

Hi QlikView users,

I would  like to seek help, I am having a problem on the rounding of of the values, I have a value of 1.5 which is derived from 1500000 divided by 1000 to get value in million then when on chart. I used the number format fixed to and integer the value shows the value of 1. I also then tried this solution, Round(Sum(Fieldname) *10/10,0.1) it got the correct answer, but it affected the other values.

Please help on how to round off correctly to integer.

Thanks in advance

Royce

[Kushal_Chawda]

Can you post the sample?

[gautik92]

post the sample data

[jonathandienst]

That looks correct to me, although its not necessary if you are producing a bar/line etc chart.

If that expression is not working for you, you will need to provide more information about what is going wrong. And as always, uploading your qvw application or a representative sample will help.

[#5]

Sorry, I cannot post the sample data. would be images ok?

[vardhancse]

Hi,

If for the expression we use round function() or in number format do the changes as per required format, it will display for all the dimensions.

What exactly you are looking for.?

[sasiparupudi1]

at leaset post the numbers that you are seeing the problem with rounding.

[#8]

this is the exact value

this is with the use of Round() function

[vardhancse]

what you are trying to achieve.

Both number format and round() are same

[#10]

id like to make it round off to 2, some of the solutions are ok, but it affect other values on the bar chart which makes the other values incorrect.