topic Re: creating qvds by passing table names into variables in App Development

creating qvds by passing table names into variables

Anonymous — Fri, 08 Jan 2016 19:20:48 GMT

I'm working on a extraction qliksense qvf. I have written a loop which passes the tablename into a variable .But Qliksense throws error the same approch works in qlikview

The following line of code throws error

here the varirable hold table names,pathnames .

Has anybody faced this issue?

Re: creating qvds by passing table names into variables

Gysbert_Wassenaar — Fri, 08 Jan 2016 19:21:58 GMT

Yes, see this blog post: Qlik Sense Legacy mode

Re: creating qvds by passing table names into variables

Anonymous — Fri, 08 Jan 2016 19:51:39 GMT

Thank you for the quick response

I changed it to StandardReload=0 in the setting.ini ,closed all the QS instances.Opened a new qliksense instance

but still I can't get the code to work right

Re: creating qvds by passing table names into variables

rwunderlich — Fri, 08 Jan 2016 20:57:41 GMT

I think you just have your quotes in the wrong place. Try removing the quotes.

-Rob

Re: creating qvds by passing table names into variables

reddy-s — Fri, 08 Jan 2016 22:50:52 GMT

Hi Balraj,

I think its the Quotes which is causing the issue. Try removing the quotes and run the script.

Thanks and Regards,

Sangram Reddy.

Re: creating qvds by passing table names into variables

Anonymous — Tue, 12 Jan 2016 14:44:10 GMT

Thank you Sangram and Rob,unfortunately after getting rid of the quotes the tables are stored as' Drop Table tablename.qvd'

Its not able to interpret

$(vPath)\$(vTableName).QVD (QVD);

I have initialized vPath as

Set vPath='//Repository/';

and '//Repository/';

I also tried sing the the lib statement

Re: creating qvds by passing table names into variables

Anonymous — Tue, 12 Jan 2016 16:00:06 GMT

the only thing that seems to be working is:

STORE $(vTableName) INTO $(vTableName).qvd(qvd);

The problem with the above code is it creates the qvds in the qvw_extraction folder ,but I want it to be created in the qvd folder

How about executing a Bat file through qlikSense editor ,this bat file moves all the qvds from one place to another.

Has anybody implemented this ?

Re: creating qvds by passing table names into variables

Anonymous — Tue, 12 Jan 2016 16:28:55 GMT

I tried
STORE $(vTableName) INTO $(vTableName).qvd(qvd);

then executed a dos command(bat file) via script editor to move all the qvds to the target location

Re: creating qvds by passing table names into variables

reddy-s — Tue, 12 Jan 2016 18:19:01 GMT

Great!

Re: creating qvds by passing table names into variables

greenee — Thu, 20 Jul 2023 16:37:31 GMT

I know it's an old post, but might help someone.

Set a variable for the various locations you want to have in a text file.
e.g. D:\QlikView\QVSScripts\PATHS.TXT

(change the dots for the directories as necessary from where you are doing the creating.qvw)
SET vQVD_Extract = '..\..\Datastore\Extract';
SET vQVD_Transform = '..\..\Datastore\Transform';

Add the
$(include=..\..\QVSScripts\PATHS.TXT); to each of your files as a default.

Then just add a variable in front of the 2nd vTableName

STORE $(vTableName) INTO $($vQVD_Extract)\(vTableName).qvd(qvd); (for extracted QVDs)
or
STORE $(vTableName) INTO $($vQVD_Transform)\(vTableName).qvd(qvd); (for transformed QVDs etc.)

Depending where you want to put them.

Regards

Greenee