topic Re: open remote qlik sense app with external VBS in App Development

open remote qlik sense app with external VBS

yogendra_wasaik — Fri, 22 Dec 2017 04:58:13 GMT

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.

Re: open remote qlik sense app with external VBS

rwunderlich — Fri, 22 Dec 2017 20:59:55 GMT

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

Re: open remote qlik sense app with external VBS

yogendra_wasaik — Tue, 26 Dec 2017 04:50:00 GMT

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

Re: open remote qlik sense app with external VBS

rwunderlich — Tue, 26 Dec 2017 15:52:03 GMT

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

Re: open remote qlik sense app with external VBS

yogendra_wasaik — Wed, 27 Dec 2017 04:21:23 GMT

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

Re: open remote qlik sense app with external VBS

rwunderlich — Tue, 02 Jan 2018 18:43:42 GMT

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

Re: open remote qlik sense app with external VBS

yogendra_wasaik — Wed, 03 Jan 2018 11:43:13 GMT

Thank you Rob for information.

- Yogendra