Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

sashokku
Contributor

Problem with creating calendar measure. No date fields detected

I tried to create a calendar measure. But when I right click on to a field to create a calendar measure it says no date fields detected. I followed this step

http://help.qlik.com/en-US/sense/3.2/Subsystems/Hub/Content/Measures/create-calendar-measure.htm 

But when I tried to pull in the field it is coming up as date but I am not able to create calendar measure.  Can some one help me out. Thanks.

Tags (1)
1 Solution

Accepted Solutions
sashokku
Contributor

Re: Problem with creating calendar measure. No date fields detected

Found an answer for it. Thought, it might be useful for someone.

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.



Create calendar measures ‒ Qlik Sense

3 Replies
mov
Esteemed Contributor III

Re: Problem with creating calendar measure. No date fields detected

Possibly your "date" field is actually a text field.  If this is the case, use date#() function in the script to convert it to a valid date.

sashokku
Contributor

Re: Problem with creating calendar measure. No date fields detected

Thanks Michael. Yes,I did it already. Now, the fields are showing up as date. But I am not able to create calendar with that.

sashokku
Contributor

Re: Problem with creating calendar measure. No date fields detected

Found an answer for it. Thought, it might be useful for someone.

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.



Create calendar measures ‒ Qlik Sense