Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Round off value incorrect

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

29 Replies
Kushal_Chawda

Can you post the sample?

gautik92
Specialist III
Specialist III

post the sample data

jonathandienst
Partner - Champion III
Partner - Champion III

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.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable
Author

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

vardhancse
Specialist III
Specialist III

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
Master III
Master III

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

Not applicable
Author

roundoff1.png this is the exact value

roundoff2.png this is with the use of Round() function

vardhancse
Specialist III
Specialist III

what you are trying to achieve.

Both number format and round() are same

Not applicable
Author

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.