import excel format

[#1]

I just started exploring the possibilities of  qliksense (qlikview user for several years).

I have an issue with importing excel data.

Numbers seems to be imported in fixed format with 6 decimals.
For measures that is fine, with numeric keys give problem.
Some of my data are loaded from database.
Customerid : 6000 from database.

Customerid : 6000.000000 from excel sheet.

Dates from database are loaded as numeric

Dates from Excel are loaded as date (1/1//2017).

[teiswamsler]

Hi Guy

try using;

Text( Subfield(  Customerid, '.', 1) ) as Customerid

And try converting to date using date# funktion

Date#( DateField, 'D/MM/YYYY' ) as Date

/Teis

[#3]

Hi Teis

thanks for the feedback.