topic Re: Round number in QlikView

Round number

marco_puccetti — Thu, 18 Jun 2015 10:50:00 GMT

Why this statement return me a number like this 12.123?

This is the statement:

=Num(Avg(Date(DT_ATTIVAZIONE_CONTO) - Date(DT_APERTURA_CONTO,'DD-MM-YYYY')),'##.##')

Thanks

Marco

swuehl — Thu, 18 Jun 2015 10:54:11 GMT

Because QV handles dates as dual values with a text and a numeric representation.

Aggregating a date difference using avg() will return a number, and num() will format the number according the format code.

sivarajs — Thu, 18 Jun 2015 11:01:20 GMT

use Num(exp,'#,##0')

marco_puccetti — Thu, 18 Jun 2015 13:56:18 GMT

For other number it works like this, truncating the number:

=Num(Avg(Date(DATA1) - Date(DATA2,'DD-MM-YYYY')),'##')

but it still continue to add a decimal value like: 11.2

Any solution?

Thanks

Marco

sivarajs — Thu, 18 Jun 2015 14:14:54 GMT

In properties, fix the number format to integer in number tab and check.

Kushal_Chawda — Thu, 18 Jun 2015 14:18:59 GMT

Use floor or round on top of the Avg

use num( avg( expression) ,'00')

marco_puccetti — Thu, 18 Jun 2015 14:44:43 GMT

Thanks

Marco