open remote qlik sense app with external VBS

[yogendra_wasaik]

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.

[rwunderlich]

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]

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]

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]

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]

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]

Thank you Rob for information.

- Yogendra