topic Re: Qlikview functions not turning Blue in QlikView

Qlikview functions not turning Blue

Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

Can someone guide me towards the right way of making a QVD. I'm trying to make a QVD but some weird, odd reason the Qlikview functions such as ODBC Connect isn't turning blue or other functions such as Store INTO Drop. When I hit reload no data shows up.

Thanks in Advance,

Re: Qlikview functions not turning Blue

alexdataiq — Thu, 03 Mar 2016 17:26:57 GMT

You have a ' (single quote) character in your path, in the vQVDLocation variable.

You can try with:

SET vQVDLocation = [..\Laura's\Data];

Or avoid using paths with "special" characters".

Regards.

Re: Qlikview functions not turning Blue

Thu, 03 Mar 2016 17:29:12 GMT

Thanks Eduardo.....

Re: Qlikview functions not turning Blue

Thu, 03 Mar 2016 17:36:04 GMT

The data loads perfectly but the script execution fails and it states to reload Old Data. Do you have any insights on what's going on?

Re: Qlikview functions not turning Blue

alexdataiq — Thu, 03 Mar 2016 17:58:04 GMT

Try enclosing the Path with square brackets [] too. I.e.:

STORE CustomerCuration INTO [$(vQVDLocation)\CustomerCuration.qvd] (qvd);

That could help.

Also, does the folder your trying to save already exists? If it doesn't, you should create it first, otherwise the Script will fail with a General Script Error.

Regards

Re: Qlikview functions not turning Blue

Thu, 03 Mar 2016 18:03:07 GMT

I have removed the apostrophe ' from the name and the data loads but the Execution of script fails.

Re: Qlikview functions not turning Blue

alexdataiq — Thu, 03 Mar 2016 18:10:42 GMT

Mmm, maybe there is an issue with the relative paths you're using?

vQVDLocation points to ..\Laura\Data.

Give than your file path currently is: C:\QV Project\Laura\Extract\QVDMaker.qwv

That means that the app will try to save to C:\QV Project\Laura\Laura\Data

(one folder up because of the .. and then Laura\Data)

So, assuming you want to save the QVD File in C:\QV Project\Laura\Data\ then your variable should be

SET vQVDLocation = '..\Data'

And the folder Data must exist already.

Regards