2 Replies Latest reply: Mar 13, 2017 10:45 AM by Guy Minnen RSS

    import excel format

    Guy Minnen

      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).