Calendar measure - no date detected - load editor

[ioannagr]

Hello everyone.

So I want to create calendar measures, but the date fields are not recognized as such,

First of all, in the ''Main'' section of the script I changed the format to the format my data are presented it. Is this correct?

I also changed the date field I want to work with from integer (as it is recognized) to date with the DATE() function. Still doesn't work.

What do I do?

I read somewhere that I need to upload the table in which my date fields and the fields I want to aggregate  in the Data Manager , but then what about all the changes I have made so far in the script for this table?

I need someone to give me clear directions on this.

Thanks a lot,

Ioanna.

[JordyWegman]

Hi Ioanna,

Can you post some script? Because then we can literally see if there are any problems, now this is really hard.

For setting date formats you can use Date#() and Date().

Jordy

Climber

[ioannagr]

I'm afraid I can't. 😞

From what I'm aware of, if the date fields are correctly recognized, then in the front-end it's easy-peasy to create calendar measures.

But this time I created my schema with load editor and this is my first time.

I need some calendar measures on the front end but the date fields are not recognized as such.

Qlik sense Help says:

"Calendar measures do not support calendars created using the Data load editor. If you use calendars created using Data load editor and want to create calendar measures, you must load a table containing a date field using Data manager for use with your tables loaded using Data load editor."

Can you explain what I need to do with clear steps? 

Many many thanks!

Ioanna

[RaduM]

Did you manage to solve this? i am in the same situation.