QlikView returns values as numeric which is "1-1-1" and "-1-1-1"
Article Number: 000004845 | Last Modified: 2019/01/17
Loading following data, QlikView returns some of values as numeric.
Load script sample is here.
LOAD * INLINE [
QlikView always use a numeric interpretation as default since this matches our assembler core and improves performance significantly over the more traditional, intrinsic, text interpretation.(i.e. a two-digit year with a minus one offset interpretation resulting in a date format based on an underlying numeric value).
The absolute rule here is that as long as a numeric value is NOT intended for arithmetic operations it should ALWAYS be formatted as a text-string using the text() function