topic Re: Rounding of percentage value in QlikView

Rounding of percentage value

Wed, 25 Nov 2020 16:16:04 GMT

I have a senario where i have to round the values

the data is as below

country value output

a 12.56 % 13 %

b 10.2 % 10 %

if the value after the point is >= 5 then it should make it as 13

if the value after the point is < 5 then it should make it as 10

Regards

Re: Rounding of percentage value

trdandamudi — Sun, 16 Oct 2016 15:39:39 GMT

You can use Round function...

Dimension: Country

Expression: Round(value)

Re: Rounding of percentage value

Sun, 16 Oct 2016 16:01:34 GMT

Hi tirumala i can use round but the my requirement is different,

if the value after point is >=5 then it should round to the next number

if it is less than 5 then it should round to the same number

Re: Rounding of percentage value

Anonymous — Sun, 16 Oct 2016 16:07:25 GMT

Is that not what rounding does?

Re: Rounding of percentage value

holmlund — Sun, 16 Oct 2016 16:08:52 GMT

If(frac(value)>=0.5, Round(value), value) or if value is decimal just Round(value, 0.01).

Re: Rounding of percentage value

Sun, 16 Oct 2016 16:12:50 GMT

Hi Aron

this is what i'm getting

can you please help me

Re: Rounding of percentage value

Sun, 16 Oct 2016 16:13:38 GMT

the first column is with out rounding and secondone is with rounding

Re: Rounding of percentage value

Anonymous — Sun, 16 Oct 2016 16:20:02 GMT

something is going on in that chart that I am not privy to.

If you could create a sample version of this data and upload it here, maybe I can give you a better answer.

Re: Rounding of percentage value

trdandamudi — Sun, 16 Oct 2016 16:23:21 GMT

Round function works exactly as you described. I just took few values you provided and it is giving correct results. Please check your expressions or script to make sure you have the correct definition of the fields..

Re: Rounding of percentage value

Sun, 16 Oct 2016 16:25:06 GMT

Hi Aron, i'm doing an accumilation to get these percentage values, will that effect the chart

i'm using the below expression to get the percentage values and acumilating it 10 steps backward

=round(sum({<IsSameMonth={'1'}>}TOT)/sum({<IsSameMonth={'1'}>}total(TOT)) * 100, 0.01)

Re: Rounding of percentage value

Anonymous — Sun, 16 Oct 2016 16:30:28 GMT

Probably?

I would think its the accumulation because the rounding occurs before the accumulation which results in +/- integer

Re: Rounding of percentage value

Anonymous — Sun, 16 Oct 2016 16:31:43 GMT

You know what you could do is just forget the rounding function and use the integer format in the number tab. That will do the rounding AFTER the accumulation.

Re: Rounding of percentage value

Sun, 16 Oct 2016 16:36:20 GMT

Hi Aron thanks a ton, it worked thank you so much

=round(sum({<IsSameMonth={'1'}>}TOT)/sum({<IsSameMonth={'1'}>}total(TOT)) * 100, 0.01)

i used the above expression and set the number format to integer

thank you so much

Re: Rounding of percentage value

Sun, 16 Oct 2016 16:40:14 GMT

can you please help me out in this

largest 5 values in staright table

Top two values in current month comparing the same values with previous month

Re: Rounding of percentage value

Sun, 16 Oct 2016 20:59:24 GMT

I will have a try on this as well