Hi, im new in QlikView and in make a board to integrate data from different databases and all well fine, but when i try to see this values in a chart some data is not there and found a strange problem with dates and i don't know how to fix it, i attached a image
I think it's a subject of the databases, in both the data type is date but the collage are different in one is Modern_Spanish_CI_AS and the other isLatin1_General_CI_AS, could it be that? and if so, how do I fix it?
Without any measures on the fields by loading the data will be a date only interpreted as date if it has the format as in the default-variables (at the beginning of the script). This means you need to convert and format all date-fields which are different to it. This could be done with: date(date#(DATE, 'FormatString')) and if there are multiple different formattings within a single field maybe with: alt(date(date#(DATE, 'FormatString1')), date(date#(DATE, 'FormatString2'))).