Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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

Re: Round off value incorrect

Can you post the sample?

gautik92
Valued Contributor III

Re: Round off value incorrect

post the sample data

MVP
MVP

Re: Round off value incorrect

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

Re: Round off value incorrect

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

vardhancse
Valued Contributor II

Re: Round off value incorrect

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
Honored Contributor III

Re: Round off value incorrect

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

Not applicable

Re: Round off value incorrect

roundoff1.png this is the exact value

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

vardhancse
Valued Contributor II

Re: Round off value incorrect

what you are trying to achieve.

Both number format and round() are same

Not applicable

Re: Round off value incorrect

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.

Community Browser