topic Re: invalid path error in QlikView

invalid path error

Wed, 04 Nov 2015 10:32:32 GMT

i wrote down this but got an error:

INV_TOP_CUSTOMERS:

LOAD

IVCOST,

IV,

IVDATE,

TYPE AS IV_TYPE,

CURRENCY ,

TOTPRICE AS IVA_TOTPRICE,

COMP as INV_COMP,

BONUSFLAG AS IVA_BONUSFLAG

from [lib://clinton/InvoiceItems.qvd](qvd)

/*WHERE IVCOST > 10000*/

ORDER BY IVDATE ASC;

concatenate (INV_TOP_CUSTOMERS)

LOAD

CUST,

CUSTNAME,

COUNTRY,

CURRENCY

FROM [lib://clinton/customers.qvd](qvd);

concatenate (INV_TOP_CUSTOMERS)

LOAD

COST,

CURRENCY,

FROM [lib://clinton/Trans.qvd](qvd);

concatenate (INV_TOP_CUSTOMERS)

LOAD

IVDATE,

CURRENCY,

IVNUM as INV_NUMBER,

FINAL AS INV_FINAL

RESIDENT [lib://clinton/Invoices.qvd]

ORDER BY INV_NUMBER ASC;

Re: invalid path error

hic — Wed, 04 Nov 2015 10:40:52 GMT

You cannot use Order By here. It only works together with Load ... Resident.

HIC

Re: invalid path error

Wed, 04 Nov 2015 10:46:35 GMT

i changed the script but keep getting the same error msg:

INV_TOP_CUSTOMERS:

LOAD

IVCOST,

IV,

IVDATE,

TYPE AS IV_TYPE,

CURRENCY ,

TOTPRICE AS IVA_TOTPRICE,

COMP as INV_COMP,

BONUSFLAG AS IVA_BONUSFLAG

from [lib://clinton/InvoiceItems.qvd](qvd)

WHERE IVCOST > 10000 ;

concatenate (INV_TOP_CUSTOMERS)

LOAD

CUST,

CUSTNAME,

COUNTRY,

CURRENCY

FROM [lib://clinton/customers.qvd](qvd);

concatenate (INV_TOP_CUSTOMERS)

LOAD

COST,

CURRENCY,

FROM [lib://clinton/Trans.qvd](qvd);

concatenate (INV_TOP_CUSTOMERS)

LOAD

IVDATE,

CURRENCY,

IVNUM as INV_NUMBER,

FINAL AS INV_FINAL

from [lib://clinton/Invoices.qvd](qvd);

Re: invalid path error

Clever_Anjos — Wed, 04 Nov 2015 10:48:46 GMT

Try

concatenate (INV_TOP_CUSTOMERS)

LOAD * ORDER BY INV_NUMBER ASC;

LOAD

IVDATE,

CURRENCY,

IVNUM as INV_NUMBER,

FINAL AS INV_FINAL

RESIDENT [lib://clinton/Invoices.qvd];

Re: invalid path error

miguelbraga — Wed, 04 Nov 2015 11:15:00 GMT

Hi Clever Anjos,

Can we make a resident load from a qvd file? I might be very wrong, but I don't think it is possible...

Regards,

Re: invalid path error

Wed, 04 Nov 2015 12:39:26 GMT

O.K i have changed the syntax and still got the same reuslt...

INV_TOP_CUSTOMERS:

LOAD

IVCOST,

IV,

IVDATE,

TYPE AS IV_TYPE,

CURRENCY ,

TOTPRICE AS IVA_TOTPRICE,

COMP as INV_COMP,

BONUSFLAG AS IVA_BONUSFLAG

from [lib://clinton/InvoiceItems.qvd](qvd)

WHERE IVCOST > 10000 ;

concatenate (INV_TOP_CUSTOMERS)

LOAD

CUST,

CUSTNAME,

COUNTRY,

CURRENCY

FROM [lib://clinton/customers.qvd](qvd);

concatenate (INV_TOP_CUSTOMERS)

LOAD

COST,

CURRENCY,

FROM [lib://clinton/Trans.qvd](qvd);

concatenate (INV_TOP_CUSTOMERS)

LOAD

IVDATE,

CURRENCY,

IVNUM as INV_NUMBER,

FINAL AS INV_FINAL

from [lib://clinton/Invoices.qvd](qvd);

Re: invalid path error

hic — Wed, 04 Nov 2015 13:52:18 GMT

Does the library path 'lib://clinton/' exist? After all - if the error message is "Invalid Path", I would suspect that the path is incorrect.

HIC

Re: invalid path error

Wed, 04 Nov 2015 14:11:14 GMT

it looks like regardless of the syntax chnages you make, the invalid path error still exists. Please verify it exists and the user you are running under has access to it.

you can paste lib://clinton into your windows explorer address bar