Skip to main content

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
QlikWorld 2023, a live, in-person thrill ride. April 17 - 20, 2023, in Las Vegas! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Lauri
Specialist
Specialist

How to keep date from becoming an integer in a mixed-format field

I have a load script that imports various CSVs and QVDs. One of the fields, ObservationValue, contains a mix of text, dates and numbers. Depending on the order that the files are loaded in, some of the dates get converted to integers, but I want them to stay in their original date format. I would rather not force the field to be Text. Is there any other way to guarantee that all values will appear exactly as they were in the source files?

Labels (1)
1 Solution

Accepted Solutions
MarcoWedel

If those values are loaded having a numerical value then the assigned text format will be taken from the first occurrence of each value. I think the only guaranteed way to keep the original text representation is to load as text (using the text() function).

View solution in original post

2 Replies
MarcoWedel

If those values are loaded having a numerical value then the assigned text format will be taken from the first occurrence of each value. I think the only guaranteed way to keep the original text representation is to load as text (using the text() function).

Lauri
Specialist
Specialist
Author

Thank you, Marco. The curious thing: Even within the same load, some dates appear as integers, and some don't. I can't determine why. I will use your suggestion with Text().