topic Interge and Decimal in QlikView

Interge and Decimal

Tue, 15 May 2012 20:32:39 GMT

how do you get the whole number and then the decimal?

Example: 1500.90

I want only what is before the point and then just what is the point after.

Result: 1500

Result: 90

thank you

goldnejea8 — Tue, 15 May 2012 20:38:20 GMT

Try something like this

subfield(NUMBER,'.',1) as [Before Decimal]

subfield(NUMBER,'.',2) as [After Decimal]

goldnejea8 — Tue, 15 May 2012 21:19:46 GMT

And if you need to make sure it is still a number after the fact, you could try something like this:

num(subfield(NUMBER,'.',1),'# ##0,#') as [Before Decimal]

num(subfield(NUMBER,'.',2),'# ##0,#') as [After Decimal]