Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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?

1 Solution

Accepted Solutions
Gysbert_Wassenaar

After using the Data Manager to import the excel data switch over to the Data Load Editor to change the load statement manually.


talk is cheap, supply exceeds demand

View solution in original post

3 Replies
Gysbert_Wassenaar

After using the Data Manager to import the excel data switch over to the Data Load Editor to change the load statement manually.


talk is cheap, supply exceeds demand
Not applicable
Author

Thank you for the answer.

Glad somebody from the Community answered almost after 45+ views

Agree with your answer. That is definitely one-dimensional.

Did not explore QlikView much, but in QlikSense liked the flexibility of Data Manager to go back and try to change fields. Doing from Data load editor is more like programming perspective.

Anyways, in my opinion more flexibility to the user from Data Manager can add to more simplicity.

Gysbert_Wassenaar

Yeah, it would be nice to be able to overrule the 'suggestions' of the Data Manager.


talk is cheap, supply exceeds demand