topic Re: Hot to use the num() function to round up in QlikView

Hot to use the num() function to round up

Fri, 31 Jul 2015 11:10:43 GMT

Hey,

I'm trying to round up a number in a text box using the num() function.

I'm currently using the script: num(sum(budget),'#.##0',',','.') and getting the result: 35.756.

How should the script be if I want the result to be: 35.8?

Thanks,

Re: Hot to use the num() function to round up

Qrishna — Fri, 31 Jul 2015 15:17:21 GMT

=round( 35.756,0.1)

Re: Hot to use the num() function to round up

swuehl — Fri, 31 Jul 2015 15:24:04 GMT

Your value is 35756 (without the thousand separator) and you want it to show as 35.8?

Re: Hot to use the num() function to round up

Colin-Albert — Fri, 31 Jul 2015 15:26:08 GMT

num() is a number formatting function,

To round a number, use round(), floor() or ceil().

Re: Hot to use the num() function to round up

Fri, 31 Jul 2015 15:28:19 GMT

Correct. Or to clarify; I have a function which give me a value of 35756 that I would like to round up to just one digit

Re: Hot to use the num() function to round up

Colin-Albert — Fri, 31 Jul 2015 15:34:57 GMT

round(sum(Budget) / 1000, 0.1)

Re: Hot to use the num() function to round up

swuehl — Fri, 31 Jul 2015 15:35:29 GMT

Not sure if I've understood your request correct, maybe like

=num(35768/1000,'#.0 k','.',',')

=num(35768/1000,'#.0','.',',')

Re: Hot to use the num() function to round up

MarcoWedel — Fri, 31 Jul 2015 19:58:42 GMT

Ceil(Sum(budget)/1000,0.1)

hope this helps

regards

Marco

Re: Hot to use the num() function to round up

saurabh5 — Fri, 31 Jul 2015 20:05:08 GMT

Hi,

=ROUND(SUM(SALES),0.1)

Regards

Re: Hot to use the num() function to round up

Mon, 03 Aug 2015 07:10:58 GMT

Hey Krishna,

Thanks for answering,

If I use that script, I get 35756,4 😕

Re: Hot to use the num() function to round up

Mon, 03 Aug 2015 07:11:51 GMT

Hey Colin,

If I use that script, I get 35756,4 😕

Re: Hot to use the num() function to round up

Mon, 03 Aug 2015 07:12:34 GMT

Hey Saurabh,

If I use that script, I get 35756,4.

Thanks, Peter

Re: Hot to use the num() function to round up

Mon, 03 Aug 2015 07:14:24 GMT

Hey Marco,

If I use the Ceil()-function I get 35756,4 😕

Re: Hot to use the num() function to round up

Anonymous — Mon, 03 Aug 2015 07:16:36 GMT

Hi,

try this

=Round(Sum(budget),0.1)

With Regards,

Arryan

Re: Hot to use the num() function to round up

PrashantSangle — Mon, 03 Aug 2015 07:17:12 GMT

Hi,

just one question . is your thousand seperator or decimal seperator.

Regards

Re: Hot to use the num() function to round up

Mon, 03 Aug 2015 07:19:20 GMT

Hey swuehl,

Thanks for the suggestions.

If I use =num(35768/1000,'#.0 k','.',',') I get 35756.4 k

and

If I use =num(35768/1000,'#.0','.',',') I get 35756.0

Peter

Re: Hot to use the num() function to round up

Mon, 03 Aug 2015 07:20:56 GMT

. is my thousand seperator.

Regards

Re: Hot to use the num() function to round up

qlikmsg4u — Mon, 03 Aug 2015 07:26:37 GMT

Hi,

try this

ceil(num(sum(budget)/1000,'#.##0',',','.'),0.1)

Re: Hot to use the num() function to round up

prabhas277 — Mon, 03 Aug 2015 07:30:58 GMT

Hi,

try it

=num(round(35.765,0.1))

Re: Hot to use the num() function to round up

Mon, 03 Aug 2015 07:35:51 GMT

Hi K N,

Good suggestion, still got 35756,4 though.