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: 
yogendra_wasaik
Contributor
Contributor

open remote qlik sense app with external VBS

Hello All,

I want to open my qlik sense app using external vb script file. Right now I can open my qlik view app using vb script but i want same for qlik sense app.

Please have look my vb script to open qlik view app.

filePathQV = "C:\Users\yogendra.w\Desktop\TestForVBScript.qvw"

set Qv = CreateObject("QlikTech.QlikView")

Qv.OpenDoc filePathQV

Set QvDoc = Qv.ActiveDocument

QvDoc.GetApplication.WaitForIdle

QvDoc.Clear()

QvDoc.Save

Set objSource = QvDoc.GetSheetByID("SH01")

Call objSource.Activate()

QvDoc.Fields("Country").Select "USA"

Any one please help me.

Thanks in advance.

6 Replies
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Qlik Sense does not have an "automation" interface like QlikView does. But it does have a number of APIs and integration options. Can you describe what you are trying to do in terms of the business and user experience?  We may have some suggestions then.

-Rob

yogendra_wasaik
Contributor
Contributor
Author

Hello Rob,

Thanks for your valuable feedback.

I want to integrate alexa voice with Qlik Sense application. i.e. on the voice command of alexa qlik sense will shows output.

Please let me know how can I achieve this? Is this possible with Qlik Sense? If yes then how can I achieve?

Thanks in advance

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Yes, that's possible with Qlik Sense. You'll use an extension that can receive commands from Alexa and than take action -- like make selections.  Here's video of an Alexa extension I made a few years ago (source is no longer available). https://www.youtube.com/watch?v=1LT1XJc5zpw

I wrote a server that scraped the Todo list in my account and put the commands on a queue that my Qlik Sense extension was listening to.  Since that time the Alexa "skills" API has become available so you no longer need to hack the Todo list.

I see you've also been looking at Adam Cooke's extension Qlik Branch.  Hopefully Adam will respond to your question about the download problem.

-Rob

yogendra_wasaik
Contributor
Contributor
Author

Yah, That video is the only trigger for us to make such a dashboards.

I tried for Adam Cooke's extension but it is no longer available for download as well as tried to connect with Adam but not getting reply.

Us there is any alternate way to achieve this?

-Yogendra

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

My colleague websy1985‌ is cooking up a new Alexa example. Keep an eye on this

https://twitter.com/WebsyIO/status/946788758904561665


-Rob

http://masterssummit.com

http://qlikviewcookbook.com

yogendra_wasaik
Contributor
Contributor
Author

Thank you Rob for information.

- Yogendra