3 Replies Latest reply: Jul 14, 2016 5:40 AM by Gysbert Wassenaar RSS

    In QlikSense Desktop, import of float number is detected as Timestamp

    Raghu I

      arasantorule (Added for better visibility)

      @

       

      Using QlikSense Desktop 3.0

       

      Trying to import data to plot Distance travelled over time (x-axis).

       

      Distance values are like 41049.74 (feet). While importing data from .xls, Prepare data shows automatically as Timestamp. And doesn't have option to reset the behaviour. Please look at the attachment.

       

      Temporary Workaround: For now removed the decimal value and kept the Distance like an Integer. Now System while import is taking as General format. I am looking to import to get full decimal value as a number.

       

      Any suggestions?