Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

quriouss
Contributor III

Load value as integer?

I have some values being loaded from an OLE DB connection to SAP BW.  They are integers (either 1 or NULL() ) but the ones are being imported as 1.00

How do I force the LOAD statement to treat them as integer values?  (I can multiply by 1 but that seems an inelegant solution).

2 Replies

Re: Load value as integer?

May be this:

LOAD Num(Field, '##') as Field

or may be one of these

Round(Field) as Field

Ceil(Field) as Field

Floor(Field) as Field

Re: Load value as integer?

Try it with: floor(Field)

- Marcus

Community Browser