topic Can you help me with this script issue? in QlikView

Can you help me with this script issue?

Tue, 28 Jun 2011 14:57:46 GMT

Hello Experts,

I have the below in my script but its not working?

CONNECT TO $(StrConnMonthly);

$(Include=ScriptFiles\Calendar.qvs)

JOIN (calendar)
LOAD DISTINCT
*,
if(date >= monthStart(addmonths('$(vStaticDate)', -2)) and date <= '$(vStaticDate)',date(date, 'DD MMM')) as date_slider
RESIDENT
calendar;

SET vCurrentDateDashboard = 0;

I get a message, cannot find field calendar... But I am sure there is a table within the Calendar.qvs script with that same name.

Anyhelp, Thanks in advance.

Can you help me with this script issue?

Anonymous — Tue, 28 Jun 2011 15:06:31 GMT

It may be a simple thing like the table in the QVS is called Calendar rather than calendar i only mention this as you do not seem 100% certain the table in there.

Can you help me with this script issue?

Tue, 28 Jun 2011 15:15:38 GMT

Hello Shay,

I figured out the issue I had with that. Actually I dint had the script file folder in the same folder as my QVWs hence it was not showing any relevant error message for the script file itself and I was confused because of this. Anyways its fixed now and Thanks again for your attempt to help.

Mady