topic Re: get rid of decimal points in QlikView

get rid of decimal points

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

I have a Calculated Dimension and if i could use a number function from the Number tab, it would work. However, there is none.

But my dimension below is

if( [Data Category]='Adjusted',

Num(ACT_GBP.Materiality, '##%'))

This gives me decimal points.

I'm trying to bring back figures without decimal points in percentage form.

By asking for num ##%, i know when i will get 2 numbers back, either to one decimal point if 8.2 and no decimal point if double figures like 20 or 40.

How can i just get whole numbers?

Re: get rid of decimal points

vvvvvvizard — Thu, 01 Feb 2018 14:48:13 GMT

floor(if( [Data Category]='Adjusted',

Num(ACT_GBP.Materiality, '##%')))

Re: get rid of decimal points

vishsaggi — Thu, 01 Feb 2018 14:49:16 GMT

Did you try Num(ACT_GBP.Materialty, '#0%') ?

IF not can you share some sample data please.

Re: get rid of decimal points

bobbydave — Thu, 01 Feb 2018 14:51:57 GMT

That was exactly it

THanks