Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Regards
Isaias
Hi Dilipranjith,
I have dealt with that but it does the same
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'))).
- Marcus
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
Hi to all,
I will try your solutions but the result are the same, check the picture