topic Re: show in two decimal in QlikView

show in two decimal

soniasweety — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

i have a column name is rate and now values showing as 100.00000455 [ this column is coming from directly from DB]

i want to get as a new column with 100.00%

andrey_krylov — Wed, 31 Oct 2018 07:12:50 GMT

Hi Sony, maybe this

Num(100.00000455, '#,##0.00') & '%'

or this

Num(100.00000455/100, '#,##0.00%')

soniasweety — Wed, 31 Oct 2018 07:28:00 GMT

thanks for your response. second one looks cool

can you have look on below thread.

Frank_Hartmann — Wed, 31 Oct 2018 07:40:33 GMT

try this:

num(round(100.00000455,0.01)/100,'#.##%')

soniasweety — Wed, 31 Oct 2018 07:45:49 GMT

but it is showing all 100.00% only... as i have data like 99.988 it should not round.

it should show 99.98% ..

and can u have a look into this?