topic Re: Num function in QlikView

Num function

rdsuperlike — Wed, 06 Jun 2018 17:02:33 GMT

I am using NUM(expression,'#.0%') to get results like 78.4%.

But how do i make it whole number without decimal, i.e rounding.

I want 78.49 as 79% and 78.44 as 78%. Any ideas?

Thanks in advance

sunny_talwar — Wed, 06 Jun 2018 17:41:04 GMT

How is 78.49% = 79%? Why not 78%? Isn't the cut off 78.5%?

rdsuperlike — Wed, 06 Jun 2018 17:44:00 GMT

yeah..that is correct. 78.5 should convert to 79%. I was trying to get 2 decimal accuracy. But even 1 decimal would work

sunny_talwar — Wed, 06 Jun 2018 17:45:59 GMT

This seems to work for me

=Num(Round('78.49%', 0.01), '#.%')

Replace 78.49% with your field or expression

Neymar_Jr — Wed, 06 Jun 2018 17:59:41 GMT

Hi Ria,

May be

if(wildmatch(NUM(expression,'#.00%'),'*.49%'),

Num(NUM(expression,'#.00%')+.0001,'##.0%'),

NUM(expression,'#.0%'))

Thanks,