topic variable returning error instead of null in QlikView

variable returning error instead of null

surajap123 — Wed, 12 Aug 2015 13:26:09 GMT

!Hi Experts,

I have a variable that stores the working directory path. when I put the variable in a text object, I get the

Error: Garbage after expression "\Files"

The variable is created in UI and below are its details-

Variable--> vQVDPath

value--> \Files\

The data is properly fetched in the load script.

load..

from $(vQVDPath)\test.qvd

Thanks

MK_QSL — Wed, 12 Aug 2015 13:29:25 GMT

load..

from $(vQVDPath)test.qvd

maximiliano_vel — Wed, 12 Aug 2015 13:38:23 GMT

Try

Variable--> vQVDPath

value--> '\Files\'

Gysbert_Wassenaar — Wed, 12 Aug 2015 13:42:10 GMT

SET vQVDPath = '.\Files\'; // relative path .\

// SET vQVDPath = '\\Files\' UNC path to a share named Files

LOAD * FROM '$(vQVDPath)'test.qvd;