Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

yogendra_wasaik
New 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

Re: open remote qlik sense app with external VBS

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
New Contributor

Re: open remote qlik sense app with external VBS

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

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
New Contributor

Re: open remote qlik sense app with external VBS

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

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
New Contributor

Re: open remote qlik sense app with external VBS

Thank you Rob for information.

- Yogendra

Community Browser