topic Decimals in text box in QlikView

Decimals in text box

pgalvezt — Wed, 03 Oct 2012 14:20:45 GMT

Hello! I'm trying to eliminate the decimals

=Num(Sum(If(IDCode='39000' and Año=xAñoMax, Saldo))/Divisor)/Num(Sum(If(IDCode='19000' and Año=xAñoMax, Saldo))/Divisor) *100

I used #.##0,0 but does't work

Display 21,234556 I want 21.2

Thanks!

MayilVahanan — Wed, 03 Oct 2012 14:22:37 GMT

Try this

=Num(your expression, '#.##')

in number tab-> use fixed:2 decimal

Hope that helps

Gysbert_Wassenaar — Wed, 03 Oct 2012 14:28:21 GMT

Or you can use round in your expression: round(21.234556, 0.1) returns 21.2

pgalvezt — Wed, 03 Oct 2012 14:38:57 GMT

I tried but show the same number.

=(Round(Sum(If(IDConcepto='39000' and Año=xAñoMax, Saldo))/Divisor))/(Round(Sum(If(IDConcepto='19000' and Año=xAñoMax, Saldo))/Divisor) )

=(Sum(If(IDConcepto='39000' and Año=xAñoMax, Saldo, '#.##'))/Divisor)/(Sum(If(IDConcepto='19000' and Año=xAñoMax, Saldo, '#.##'))/Divisor)*100

Nothing happened.

Gysbert_Wassenaar — Wed, 03 Oct 2012 14:43:27 GMT

Put the round on the outside:

=round(Num(Sum(If(IDCode='39000' and Año=xAñoMax, Saldo))/Divisor)/Num(Sum(If(IDCode='19000' and Año=xAñoMax, Saldo))/Divisor) *100, 0.1)