topic Execute a QVS with $(Include........ in QlikView

Execute a QVS with $(Include........

Wed, 28 Apr 2010 09:07:39 GMT

Hi Folks

I'm having trouble getting a very simple statement to work in the load script, I have a QVS file called LDAPDataLoad.QVS stored on C:\QLIKVIEW\QVS and I have added a line in my load script as follows:

$(Include = "C:\QLIKVIEW\QVS\LDAPDataLoad.QVS")

Nothing happens at all when I run the load script, when I run it in debug it simply jumps past this line as if it doesn't exist, no errors are reported (this is normal behaviour for QlikView though, to provide completely inadequate error messaging). I am at a loss as to what I'm doing wrong here.

Any help on this would be appreciated as I'm now at the end of the road........

Execute a QVS with $(Include........

Anonymous — Wed, 28 Apr 2010 09:22:14 GMT

Did you try with single quotes instead of double qoutes??

Execute a QVS with $(Include........

Wed, 28 Apr 2010 09:31:11 GMT

Now tried double quotes, single quotes, no quotes........

$(Include = 'LDAPDataLoad.QVS')
$(Include = "DBConnectionCCDW.QVS")
$(Include = StandardVariables.QVS)

Nothing works!

Execute a QVS with $(Include........

Wed, 28 Apr 2010 10:18:05 GMT

I found the answer, all must be in lower case, and without any quotes at all, then it works.

Actually I found it because the EDIT menu in the load script has an option for include, so I used that and checked the syntax (probably should have checked the manual first).