I am loading a spreadsheet into Qlikview that contains timestamp data in one of the columns. I am using the wizard to create the load statement within the script and when I go into the 'transformation step' the timestamp column is transformed to a numeric field that contains a number of decimal places. As a consequence, I lose the format of the timestamp data. How can I retain the format so that I can then use the timestamp data as individual date and time fields within the presentation ?
Dates and timestamps in qlikview have both a numeric and a text (formatted) value. You can use the date(), time() and timestamp() functions to specify the textual formating. If you're loading a large number of records it's recommended to split the timestamp into separate date and time fields. Qlikview can store these more effeciently because the cardinality of the separate parts is a lot smaller than of the timestamp.