Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
dmohanty
Partner - Specialist
Partner - Specialist

Any job/batch script to Click a button automatically in a QVW?

Hi All,

I have a Button in a QVW which executes a Macro successfully to generate email. I have to open the QVW, Click the Button once (executes Macro) and the Email will come in Outlook.

But I tried using the OnPostReload and OnOpen triggers but unfortunately Macro never works in that. So doing every day manually to click the button to get the output.

Is there any way, any batch script or any task that can click the Button in the QVW automatically at a desired time period?

Any suggestions are welcome!

Regards!

9 Replies
passionate
Specialist
Specialist

Hi Dicky,

You can control Qlikview through excel macro.

So, try using Excel macro to open Qlikview document and perform required operations.

Regards,

Pankaj

dmohanty
Partner - Specialist
Partner - Specialist
Author

Hi passionate,

Thanks for suggestion.

I had never used Excel Macros to control Qlik, but surely will give it a try.

I believe again that will be a manual task to Run Excel Macros?

passionate
Specialist
Specialist

Hi Dicky,

- Create a Vba code to open Qlik Document. (Sample of QlikView automation by external VBScript scripts · blog.infovizion.ru)

- Perform Required operations.

Note: You can try auto scheduling the vba script. (.vbs file)

Regards,

Pankaj

dmohanty
Partner - Specialist
Partner - Specialist
Author

@passionate,

Great help buddy!

Now I can use the VBS to Open a QVW and some small desired actions.

Can you provide some more help in how and where to automate my VBS Script?

passionate
Specialist
Specialist

Hi Buddy,

Best way to trigger VBA script on particular time is through windows task.

Create a task to execute vbs file and schedule it in windows as per your requirement.

Regards,

Pankaj

dmohanty
Partner - Specialist
Partner - Specialist
Author

Hi passionate,

VBS file is scheduled and running as per triggered schedule. But it's really not opening up the QVW.

However the VBS logs shows no error. When run from local, it opens up the QVW, but not through scheduler.

Note - My QVW is in SAN drive.

dmohanty
Partner - Specialist
Partner - Specialist
Author

Hi passionate,


I was able to achieve this using a Batch Script that runs as Trigger in Windows Scheduler.


But I will still work, why its not working in VBS while reloaded as Trigger.


Thanks again for the suggestions.

passionate
Specialist
Specialist

Hi Dicky,

So you are handling QVW document through Batch script?

Regards,

Pankaj

dmohanty
Partner - Specialist
Partner - Specialist
Author

Yes passionate‌,

As of now, only for this particular QVW to fulfill the requirement.

An Open command/scheduler to open the QV.exe and the desired App-

"C:\Program Files\QlikView\QV.exe" "YoyrPath\YourApp.qvw" >> openlog.txt  exit

A close command/scheduler with to close the QV.exe to save memory in Task Manager-

taskkill /f /IM E:\Program Files\QlikView\QV.exe >> log.txt

This helps the requirement at least.