topic Common Calendar in QlikView

Common Calendar

Mon, 17 Mar 2014 15:55:54 GMT

Hello,

I've read up on several threads on creating a "Common Calendar" and have yet to find one that explains how to do it in a concise and simple manner for someone like me, who knows absolutely nothing about Qlikview or SQL or scripting.

What I have learned so far is from copying other peoples' work and importing a couple of Excel tables into a .qvd file, but the script I've got to generate a common calendar always errors out with this message, which I don't understand at all:

To anyone with a little spare time, can you please explain to me what this error means and exactly how to fix it? I've attached my rudimentary common calendar file as well.

Thank you for your help.

Re: Common Calendar

alexandros17 — Mon, 17 Mar 2014 16:06:28 GMT

In your script in the tab test data you drop testdata table, then you try to load it again ... but obviously don't find it.

To fix, move drop of table testdata to the end of the script

Re: Common Calendar

giakoum — Mon, 17 Mar 2014 16:08:21 GMT

The script you are using defines the sub for creating a calendar. You need to call the sub to actually create it. let's suppose that you want to create a calendar based on your field [Report Date]. Then you need to call the sub as follows :

CALL CalendarFromField('Report Date', 'ReportDateCalendar', '_');

where ReportDateCalendar will be the table name of your new calendar table and _ the fields prefix (can be omiited). If you need an additional calendar on some other date field, then you need to call the sub again, changing parameters. For example :

CALL CalendarFromField('Bank Open Date', 'BankOpenDateCalendar', '_');

Try it and observer the results.

Re: Common Calendar

Mon, 17 Mar 2014 21:18:42 GMT

Thanks for both of your quick replies! I've got a fire to put out, but will try out both of your suggestions ASAP.

Much appreciated,

Egan

Re: Common Calendar

Thu, 27 Mar 2014 20:38:26 GMT

Hi Alessandro,

When you suggested to move the line, 'DROP Table TestData;', it already is the last statement in that tab. Do you mean to demote that tab to the very bottom? If so, is there a way to keep that tab untouched but move that line somewhere else?

Thank you

Re: Common Calendar

Thu, 27 Mar 2014 20:42:54 GMT

Hi Ioannis,

Where should the script commands that you are suggesting be created? In an existing tab or a new one? I don't understand the reasoning or logic behind the Qlikview tab structure so sorry if my question seems so simple.

Thank you

Re: Common Calendar

giakoum — Fri, 28 Mar 2014 07:51:16 GMT

They should be created anywhere, but after the lines the sub is defined.