topic Re: Master Calendar Interval () step error in QlikView

Master Calendar Interval () step error

jleefjcapital — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I'm using the following code for the master calendar. It had worked with no problem with other data sets, but I get the following error message, when I try to use it with a particular data table (Alabama_employ).

I hope someone would be able to help me.

Thank you,

Jessica

Error message when I try to load:

Here is the master calendar code I'm using:

Here is the table I'm referencing:

Re: Master Calendar Interval () step error

sunny_talwar — Tue, 25 Oct 2016 19:17:28 GMT

MakeDate function create a date and you don't need Date#() for Qlik Sense to understand that it is a date. Try this:

Date(MakeDate(year, Right(period, 2)), 'M/D/YYYY') as DATE,

to replace this

Re: Master Calendar Interval () step error

jleefjcapital — Tue, 25 Oct 2016 19:21:44 GMT

Great, thank you. However, I still get the following error message - I think it's on the master calendar side.

Re: Master Calendar Interval () step error

sunny_talwar — Tue, 25 Oct 2016 19:23:27 GMT

Can you share how year and Period look in there raw formats?

Re: Master Calendar Interval () step error

jleefjcapital — Tue, 25 Oct 2016 19:24:27 GMT

Year = 1990, 1991, etc

Period = M01, M02, etc.

Re: Master Calendar Interval () step error

sunny_talwar — Tue, 25 Oct 2016 19:27:00 GMT

Try this out:

Date(MakeDate(year, (Right(period, 2) * 1)), 'M/D/YYYY') as DATE,

Date(MakeDate(year, Num#(Right(period, 2), '##')), 'M/D/YYYY') as DATE,

Re: Master Calendar Interval () step error

jleefjcapital — Tue, 25 Oct 2016 19:30:22 GMT

I get the same error message.

Re: Master Calendar Interval () step error

sunny_talwar — Tue, 25 Oct 2016 19:35:46 GMT

Can you just run your Alabama_employee table with all of these

Num(MakeDate(year, (Right(period, 2) * 1))) as DATE1,

Num(MakeDate(year, Num#(Right(period, 2), '##'))) as DATE2

Re: Master Calendar Interval () step error

jleefjcapital — Tue, 25 Oct 2016 19:38:44 GMT

Yes, it loads correctly. The problem is the master calendar step.

Re: Master Calendar Interval () step error

vinieme12 — Tue, 25 Oct 2016 19:39:13 GMT

Change this part, encapsulate in brackets

Autogenerate 1 while ($(varMinDate) + Iterno() - 1) <= $(varMaxDate);

Re: Master Calendar Interval () step error

sunny_talwar — Tue, 25 Oct 2016 19:41:19 GMT

I don't think there is any issue with your Master Calendar. Can you share the screenshot of the two new fields that we created? DATE1 and DATE2?

Re: Master Calendar Interval () step error

jleefjcapital — Tue, 25 Oct 2016 19:41:43 GMT

I get the same error message.

Re: Master Calendar Interval () step error

jleefjcapital — Tue, 25 Oct 2016 19:42:42 GMT

How do I view the data once I load?

Re: Master Calendar Interval () step error

sunny_talwar — Tue, 25 Oct 2016 19:43:38 GMT

Go to the front end of the app and create filters for the fields

Re: Master Calendar Interval () step error

jleefjcapital — Tue, 25 Oct 2016 19:55:23 GMT

I'm not sure I understand.

Re: Master Calendar Interval () step error

sunny_talwar — Tue, 25 Oct 2016 19:58:49 GMT

I just want you to load the application with Alabama_employee table and then once reloaded create a filter on DATE1 and DATE2 fields on the front end of the application just like you would create for any other field.

Make sure you have added DATE1 and DATE2 in Alabama_employee table

Num(MakeDate(year, (Right(period, 2) * 1))) as DATE1,

Num(MakeDate(year, Num#(Right(period, 2), '##'))) as DATE2

Re: Master Calendar Interval () step error

jleefjcapital — Tue, 25 Oct 2016 19:59:57 GMT

I'm really new to Qlik. I'm not sure what you mean by "creating a filter".

Re: Master Calendar Interval () step error

sunny_talwar — Tue, 25 Oct 2016 20:01:45 GMT

Do you know how to get to this screen?

Re: Master Calendar Interval () step error

jleefjcapital — Tue, 25 Oct 2016 20:03:50 GMT

Yes.

Re: Master Calendar Interval () step error

jleefjcapital — Tue, 25 Oct 2016 20:06:09 GMT

After I click on Filter, I added Date1 and Date2 one at a time as a dimension. It displays nothing. Just the field name.