Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

balrajprabhu
Contributor

creating qvds by passing table names into variables

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

Capture.PNG

Error.PNG

here the varirable hold table names,pathnames .

Has anybody faced this issue?

1 Solution

Accepted Solutions

Re: creating qvds by passing table names into variables

Yes, see this blog post: Qlik Sense Legacy mode


talk is cheap, supply exceeds demand
8 Replies

Re: creating qvds by passing table names into variables

Yes, see this blog post: Qlik Sense Legacy mode


talk is cheap, supply exceeds demand
balrajprabhu
Contributor

Re: creating qvds by passing table names into variables

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

Error.PNG

Re: creating qvds by passing table names into variables

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

-Rob

reddys310
Honored Contributor II

Re: creating qvds by passing table names into variables

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.

balrajprabhu
Contributor

Re: creating qvds by passing table names into variables

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/';

Error.PNG

I also tried sing the the lib statement

2.PNG

balrajprabhu
Contributor

Re: creating qvds by passing table names into variables

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 ?

balrajprabhu
Contributor

Re: creating qvds by passing table names into variables

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

reddys310
Honored Contributor II

Re: creating qvds by passing table names into variables

Great!