topic Re: working Auto calendar fail once Concatenating Excel File with QVD file in App Development

working Auto calendar fail once Concatenating Excel File with QVD file

Mosfet — Tue, 27 Sep 2022 12:01:06 GMT

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

Re: working Auto calendar fail once Concatenating Excel File with QVD file

williejacobs — Wed, 05 Oct 2022 07:39:59 GMT

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')

Re: working Auto calendar fail once Concatenating Excel File with QVD file

Mosfet — Wed, 05 Oct 2022 07:43:52 GMT

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