topic Re: Save QVD with relative path in QlikView

Save QVD with relative path

Anonymous — Tue, 24 May 2016 02:59:32 GMT

Hi,

Could you please help me in saving the QVD with the relative path.

My path to store the QVD is: \\wwhsbin\QlikView_Data\SalesQVDFiles

with in this in need to store SalesQVD

i am trying like ..\..\QlikViewDataFiles\QVDFiles\SalesQVD.qvd(qvd);

but it is throwing error.

Dashboard file is: \\wwhsbin\QlikView_WorkBooks\Sales\Salesworkbook.qvw

Note: i dont need any variable to hold the path i just need the relatvie path to create QVD.

Please help me

Re: Save QVD with relative path

tamilarasu — Tue, 24 May 2016 03:11:13 GMT

Try this,

STORE TableName Into ..\..\QlikView_Data\SalesQVDFiles\SalesQVD.qvd(qvd);

Re: Save QVD with relative path

Anonymous — Tue, 24 May 2016 03:20:53 GMT

thnaks for the reply

the reloading is getting falied

Re: Save QVD with relative path

tamilarasu — Tue, 24 May 2016 03:26:06 GMT

John,

Make sure the relative path option box is enabled in edit script window.

Re: Save QVD with relative path

Anonymous — Tue, 24 May 2016 03:29:36 GMT

Yes, but still the same error, dashboard failed to relaod

Re: Save QVD with relative path

tamilarasu — Tue, 24 May 2016 03:42:10 GMT

You can check the log file to find where it goes wrong. The above syntax goes two folders back and store the table inn the folders path QlikView_Data\SalesQvdFiles.. If you still get the error, try this,

Store TableName into Test.qvd (qvd);

This will store the qvd where the dashboard is placed.

Re: Save QVD with relative path

ajsjoshua — Tue, 24 May 2016 04:42:23 GMT

Hi,

Try like this

SET vPath = D:\Qlikview_project\Live Project\Qlikview Report\2.QVD\;

and load the tables using

From

[$(vPath)Product.qvd]

Re: Save QVD with relative path

Anonymous — Tue, 24 May 2016 05:51:32 GMT

Hi , thanks for the reply but i dont want these path to be set using variable

Re: Save QVD with relative path

Kushal_Chawda — Tue, 24 May 2016 05:54:21 GMT

try this

\\..\QlikView_Data\SalesQVDFiles

\\..\..\QlikView_Data\SalesQVDFiles

Re: Save QVD with relative path

Anonymous — Tue, 24 May 2016 06:02:16 GMT

thanks for the reply

but the same issue dashboard failing to reload

Re: Save QVD with relative path

tamilarasu — Tue, 24 May 2016 06:06:56 GMT

Could you post your log file.?

Re: Save QVD with relative path

Anonymous — Tue, 24 May 2016 06:13:47 GMT

please find this

24/05/2016 14:07:25: 0085 \\wwhsbin\QlikView_WorkBooks\Sales\Salesdata.xlsx]

24/05/2016 14:07:25: 0086 (ooxml, embedded labels, table is Salesdata)

24/05/2016 14:07:25: 4 fields found: Treatment Centre, Date, Domestic budget (m3), Controlled budget (m3), 144 lines fetched

24/05/2016 14:07:25: 0088 Store Salesdata into ..\..\QlikViewDataFiles\QVDFiles\SalesQVD.qvd(qvd); 24/05/2016 14:07:25: General Script Error

24/05/2016 14:07:25: Execution Failed

24/05/2016 14:07:25: Execution finished.

Re: Save QVD with relative path

CELAMBARASAN — Tue, 24 May 2016 06:16:24 GMT

Could you please tell us clearly.

Which file creates the QVD and file path of that?

Where you want to store the QVD?

Relative path can be used like below

QVD generation file present in \\wwhsbin\QlikView_WorkBooks\Sales\

if you want to store the QVD in \\wwhsbin\QlikView_Data\SalesQVDFiles

in that case you have to use

Store SalesTable into [..\..\QlikView_Data\SalesQVDFiles\SalesQVD.qvd](qvd)

Re: Save QVD with relative path

MayilVahanan — Tue, 24 May 2016 06:18:37 GMT

Please mention your qvd path and file path..

Both are in different drive or different location?

Re: Save QVD with relative path

tamilarasu — Tue, 24 May 2016 06:25:51 GMT

You mentioned that you want to store the Table in the below directory.

John Smith wrote:

My path to store the QVD is: \\wwhsbin\QlikView_Data\SalesQVDFiles

But you have used the wrong directory.

24/05/2016 14:07:25: 0088 Store Salesdata into ..\..\QlikViewDataFiles\QVDFiles\SalesQVD.qvd(qvd);

Could you confirm which folder path is correct.?

Re: Save QVD with relative path

Anonymous — Tue, 24 May 2016 06:29:44 GMT

My path to store the QVD is: \\wwhsbin\QlikView_Data\SalesQVDFiles

this is correct one

Re: Save QVD with relative path

Anonymous — Tue, 24 May 2016 06:29:51 GMT

My path to store the QVD is: \\wwhsbin\QlikView_Data\SalesQVDFiles

this is correct one

Re: Save QVD with relative path

Anonymous — Tue, 24 May 2016 06:30:05 GMT

My path to store the QVD is: \\wwhsbin\QlikView_Data\SalesQVDFiles

this is correct one

but still throwing error

Re: Save QVD with relative path

sasiparupudi1 — Tue, 24 May 2016 13:48:19 GMT

Map a n/w drive to a high level folder on the server say

z: = '\\wwhsbin\Main qlikview folder'

I am assuming that

Main qlikview folder contains folders QlikView_Data and QlikViewDataFiles

you can then use

Store SalesTable into [..\..\QlikView_Data\SalesQVDFiles\SalesQVD.qvd](qvd)

hth

Sasi