topic Re: round integer number in QlikView

round integer number

omid5ive — Tue, 14 Jun 2016 05:14:09 GMT

how can i round integer number?

for example:

i want to show 275612 ------->275000

1325----->1000

123--->100

Chanty4u — Tue, 14 Jun 2016 05:23:28 GMT

u can try this

tamilarasu — Tue, 14 Jun 2016 05:24:05 GMT

Hi Omid,

Try,

=If(Field<1000, Floor(Field,100), Floor(Field,1000))

Chanty4u — Tue, 14 Jun 2016 05:26:45 GMT

If you have values in dimension or set analysis expression then try like this

Round(Sum(Sales), 1000)

Round(Sales, 1000)

ajsjoshua — Tue, 14 Jun 2016 05:39:37 GMT

Hi,

Try

Floor(275612 )

omid5ive — Tue, 14 Jun 2016 05:40:01 GMT

thank you

tamilarasu — Tue, 14 Jun 2016 05:42:50 GMT

Did you check the other two scenarios.? It gives the wrong result.

Chanty4u — Tue, 14 Jun 2016 05:46:40 GMT

As per raj. its gives u best shot through the script.

try below script

Round:

LOAD * INLINE [

a, b

275612, num

1325, dd

123, pp

];

LOAD *,

If(a<1000, Floor(a,100), Floor(a,1000)) as new1

Resident Round;