Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

QVC include failes if SET Qvc.Global.Extension.Directory is predefined #52

Closed
veglar opened this issue Oct 13, 2016 · 0 comments
Closed

Comments

@veglar
Copy link

veglar commented Oct 13, 2016

If you have defined Qvc.Global.Extension.Directory and script fails before executing qvc.cleanup then the include of qvc.qvs failes will fail the next time you run the script.
I'm using the QVC 10.2 and Qlik Sense 3.0.3.

My test script:

$(must_include=lib://QVC/Qvc_Runtime\Qvc.qvs);
SET Qvc.Global.Extension.Directory=lib://QVC\etc\;
call qvc.calendar(today()-1000, today(), 'Test')
// call qvc.cleanup

image

I've identified the error to be caused within the Qvc.ColorTheme.

$(_qvctemp.colorTable):
LOAD trim(ColorVariable) as _qvctemp.ColorVariable,
     trim(ColorValue) as _qvctemp.ColorValue
FROM
[$(_qvctemp.themeFile)]
(ooxml, embedded labels, table is Sheet1)
WHERE len(trim(ColorVariable))>0 and left(trim(ColorVariable),2) <> '//'
;

If you put brackets around the table name declaration the problem dissapear.

[$(_qvctemp.colorTable)]:
LOAD trim(ColorVariable) as _qvctemp.ColorVariable,
     trim(ColorValue) as _qvctemp.ColorValue
FROM
[$(_qvctemp.themeFile)]
(ooxml, embedded labels, table is Sheet1)
WHERE len(trim(ColorVariable))>0 and left(trim(ColorVariable),2) <> '//'
;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant