working Auto calendar fail once Concatenating Excel File with QVD file

[Mosfet]

HI

I am working on a dashboard that connect between QVD table and external excel file.

The QVD table contain date column and once importing and loading this QVD an auto generated calendar appeared using this column.

The external excel file contain also a date column also ,with the same format.

the problem is that the auto calendar crash and didn't work once I concatenate the two tables together adding the Excel date column under the QVD date column. 

any one can explain this please

[williejacobs]

Hi @Mosfet 

What could be happening is that Qlik is not recognising the field as a date field.

I would suggest using the Date# function to specify the format for the date from your file.

eg. Date#([Main Date],'yyyy/dd/MM')

[Mosfet]

Thanks Wiliam that's what i did exactly and it works

i created another data filed contain the Date function of the Main Date after that when i concatenated the excel with this column it works fine

thanks again