how do qlikview identifies the format of a column by default itself
There is a question asked to me by someone that "when we import any file in qlikview how does it identifies the format of the column like if its an id, number, salary, etc. we do not specify which kind of data is there in the column but still qlikview identifies its type."
that blog does explains about the datatype in qlikview but my question was a bit different from it.
suppose it was written that months from jan to dec also has the numeric value 1 to 12 which is used for calculation and sorting but how dows we calculate the week using the date function when qlikview do not have any datatype??
whats the logic that it does not sums up any string values, how does it rectifies it as varcar??
Qlikview reads the first record(s) from the source and matches it to certain patterns:
If it looks like a date or date/time (matches the date and/or timestamp formats in your environment), set the formatting to date (loads a dual number with a text form as a date)
If it looks like a time (hh:mm, etc), set the formatting to time (loads a dual number formatted as a date)
If it is a number, set the type to numeric and format it like the first number.
Otherwise set to a string type
HTH
Jonathan
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
