topic Re: Qliksense Engine API for sheets in Integration, Extension & APIs

Qliksense Engine API for sheets

akeswani — Thu, 29 Nov 2018 00:20:49 GMT

Hello,

I have a web app that opens Qliksense app in an iframe.

When the user make selections, is there any way I can know which sheet the selections were made on ? So when the user post those selections (as a link ) and another user clicks on that link, he will be taken to that sheet with same selections.

i have the selections working ,by calling APIs, but i do not have a way to know what sheets the selections were made on. So today the user has to go to that sheet to see the selections. I want the user to be taken to that sheet when he clicks the link.

is it possible in Nov'18 release of QS ? it wasn't until April'18 release i think. Any API that i can call to store the sheet info?

Does anyone know?

Thanks in advance.

Re: Qliksense Engine API for sheets

rwunderlich — Thu, 29 Nov 2018 00:55:38 GMT

I would think you could extract the sheetname from the url in the iframe.

-Rob

Re: Qliksense Engine API for sheets

akeswani — Thu, 29 Nov 2018 01:52:53 GMT

hey Rob, thanks for your reply.

so even if i get the sheetname in URL (somehow, as hub displays the sheetname but my iframe doesn't!!!), is there any Qlik Engine API that can be called and passed in the sheet name or Id, to get to the sheet ?

Re: Qliksense Engine API for sheets

Øystein_Kolsrud — Thu, 29 Nov 2018 08:51:40 GMT

Is the problem that you are unable to switch sheet, or that you are unable to figure out which sheet to switch to?

Selections are not made on sheets, but on objects. Those objects may or may not be placed on a sheet. So knowing what sheet to switch to could be rather difficult. But if you know what object the selection was made on, then you could potentially check the children of the sheets to see what sheet contains that object.

Re: Qliksense Engine API for sheets

akeswani — Thu, 29 Nov 2018 14:18:52 GMT

I am unable to figure out the sheet I should switch to.

Today, we have given the option to user , in a dropdown, to select sheet they are making selections on. But that's not good.

we want to eliminate that step. we just want the user to make selections and post it as a link, so anyone can click on that link and user being in that app, the selections would be applied. The get and apply selections work, but it doesn't take the user to the sheet that the selections were made on.

Do you know if the Nov'18 release of Qliksense has any API available that can give me the info on sheet , that when we apply selections we are taken to that sheet somehow ? to your point, the object can be in multiple sheets also, so that time it's hard to find out the sheet where selections were made.

There was a demo from some other company, who showed the same thing, that the "Bot" can get to the sheet when asked a particular question. so I was wondering that it is possible to go to sheet somehow !

Re: Qliksense Engine API for sheets

rwunderlich — Thu, 29 Nov 2018 15:01:57 GMT

What URL form are you using in your iframe? Please post the url here scrubbing anything sensitive.

-Rob

Re: Qliksense Engine API for sheets

akeswani — Thu, 29 Nov 2018 21:50:22 GMT

this is the URL :

https://intranet/sense;id=b334a756-7bb1-4b4e-932f-9e97681dd607;name=License%20Monitor;inConfigQlikChannels=true

Thanks.

Re: Qliksense Engine API for sheets

rwunderlich — Fri, 30 Nov 2018 00:02:29 GMT

You can add the sheet name to your url to go to a particular sheet. See:

https://help.qlik.com/en-US/sense-developer/November2018/Subsystems/APIs/Content/Sense_ClientAPIs/app-integration-api.htm

If the iframe url is in a different domain than your page (I suspect it is) then I don't know how you can capture what sheet the user is on as you can't access iframe.contentWindow.location cross-domain.

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

Re: Qliksense Engine API for sheets

akeswani — Fri, 30 Nov 2018 21:13:19 GMT

yes Rob, the domain is different than the iframe url.

So there is no way to get to the sheet then?

Re: Qliksense Engine API for sheets

rwunderlich — Fri, 30 Nov 2018 21:45:56 GMT

Not that I can think of. You might ask over on the Qlik-Branch slack channel if you haven't already.

-Rob

Re: Qliksense Engine API for sheets

akeswani — Fri, 30 Nov 2018 22:01:31 GMT

Thanks Rob, appreciate your time.