topic Re: generic store path for qvd's in QlikView

generic store path for qvd's

Wed, 30 Nov 2011 12:58:35 GMT

Good afternoon all,

I have to store an amount of qvd's into a directory. A few things amazed me:

1. I can not use relative path. The emphasis here might be on 'I'. Maybe there is a way, but I haven't found it;

2. In an attempt to circumvent this problem I tried to SET a path variable. This didn't work; the script crashed.

Does anyone have a solution for this?

Thanks in advance,

Rob

swuehl — Wed, 30 Nov 2011 13:01:16 GMT

I usally use a variable to store the path and the reuse this variable in the STORE statement full qualified path.

Wed, 30 Nov 2011 13:05:26 GMT

This is what I tried:

SET vcQvdPath = I:\Qlikview\Qvds\

SET vcQvdPath = 'I:\Qlikview\Qvds\'

then I declared

STORE TableName INTO vcQvdPath & TableName.qvd

The script ran, but no qvd appeared in the directory.

What did I do wrong?

swuehl — Wed, 30 Nov 2011 13:09:59 GMT

Well, I think you need something like

$(vcQvdPath)

to reference the variable, in total

STORE TableName INTO $(vcQvdPath)TableName.qvd

(no Concatenation symbol needed here).

You could also look into the directory statement.

Wed, 30 Nov 2011 13:15:09 GMT

Brilliant! Thanks.

Using the right syntax takes some practising for me 🙂

johnw — Thu, 01 Dec 2011 00:09:56 GMT

If I understand what you mean by relative paths, I use them for my QVDs and almost everything else, most commonly like this:

DIRECTORY ..\..\server\masterData\QVD;

[Something]:
LOAD SomeField
FROM SomeFile.qvd (QVD)
;

But this also works fine and is equivalent:

[Something]:
LOAD SomeField
FROM ..\..\server\masterData\QVD\SomeFile.qvd (QVD)
;

I agree that you should be using relative paths.