Qlikview functions not turning Blue

[#1]

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,

[alexdataiq]

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.

[#3]

Thanks Eduardo.....

[#4]

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?

[alexdataiq]

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

[#6]

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

[alexdataiq · Accepted solution]

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