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
Solved! Go to Solution.
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'))).
the upper dates are in string so use date(date#(Fecha,'YYYY-MM-DD'),'DD/MM/YYYY')
If you have diffrent formats try
alt(your expression,date(date#(Fecha,'YYYY-MM-DD'),'DD/MM/YYYY')) and it shall fetch all the dates properly