Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
udaya_kumar
Specialist
Specialist

can qlikview publisher access vb script or jscript written in qlikview document?

Hi,

i have a scenario that,

there will be three folders in the qlikview server consider,

first, middle and final folders.

we will be creating reports for every month.

there will be jan 2012 report will be in middle folder, current month feb 2012 report will be in first folder.

there will be a application, in that there will be one button. clicking on that button,

it should move the jan 2012 report from middle folder to final and the current month report from first to middle folder.

how we can do this?

can we write a script in qlikview?  Can qlikview publisher access these script to do this task?

or can anyone give me idea or solution that how i can do it?

thanks in advance

15 Replies
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

     You can place below script in your qlikview script.

    

     Execute cmd.exe /C move d:\sample.xls d:\community;

     Like wise you can move files from one folder to another.

     But the application should be placed on server on which you have installed the QlikView.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
udaya_kumar
Specialist
Specialist
Author

Hi Kaushik,

thanks for the reply,

these script i need to add it in the qvw file right?

application which you have mentioned, is that what i mentioned in my comment right?

but that application is a java application. so how we can place this application in the server?

can you explain me in detail?

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

     Yes the script will be added to qlikview application.

     If you can tell me why you want this to be done, i will tell you the proper way to do this.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
udaya_kumar
Specialist
Specialist
Author

Hi Kaushik,

This is the client requirement. this concept is called Archival Strategy.

this should be implemented for our project so.

can you help me in getting solution for this?

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

     So you mean to say only thing you want is to get the copy of the application from one folder to another is it right?

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
udaya_kumar
Specialist
Specialist
Author

yes kaushik,

i want to move a file from one folder to other on button click

and that button is in java application.

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

     Do you mean java macro in QlikView or java application seperated from QlikView?

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
udaya_kumar
Specialist
Specialist
Author

Hi,

The java application is separate and qlikview is separate,

but the qlikview report will be integrated with the java application.

qlikview report will be shown in the java portal.

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

     One more thing i want to clear that the button you said will be in QlikView right?

     So if you click a button from QlikView, you want the folders to be moved?

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!