topic Re: Navigating to any sheet in Qliksense in Integration, Extension & APIs

Navigating to any sheet in Qliksense

Tue, 19 May 2015 22:36:44 GMT

Hello everyone,

I am trying to build an app with N sheets and to have hyperlinks to navigate to any sheet from any given sheet. E.g. if I am in first sheet, I'll have links to navigate directly to 5th sheet or 6th sheet etc without having to click Next sheet icon multiple times. I don't want to use KPI or text object as these open the sheets in new tab/window. Looks like the extension it.HtmlBox can be used to embed any HTML code, so wondering if I could use it for achieving this, may be using a href or window.open (target _self) but not sure how to get the current page and sheet id to pass as parameters. Anyone has any suggestions for this?

Thanks much for the help.

Thanks

Shree

Re: Navigating to any sheet in Qliksense

Anonymous — Tue, 19 May 2015 23:00:13 GMT

In Qlik Sense, there is a Sheet selector in the upper right corner. Isn't it what you want?

Re: Navigating to any sheet in Qliksense

Tue, 19 May 2015 23:14:07 GMT

Nope, not that one. It's for navigating to next/previous sheet, one at a time. I want to navigate to any sheet within the app in one click. e.g. say navigate to sheet 7 directly from sheet 1. I don't want to click the sheet navigator 7 times.

Thanks

Shree

Re: Navigating to any sheet in Qliksense

Tue, 19 May 2015 23:31:51 GMT

Sheet navigator shows some of the sheets alright. If my app has 20 plus sheets then it's bit of a challenge. Also user requesting for links in the page itself.

Thanks

Shree

Re: Navigating to any sheet in Qliksense

Wed, 20 May 2015 00:40:00 GMT

Shreevatsau,

That's not what Michael is talking about. He is talking about the Sheet navigator in the upper right of the client.

Is there something wrong with using this to navigate sheets?

Re: Navigating to any sheet in Qliksense

Wed, 20 May 2015 01:02:31 GMT

Hi Jeffrey,

This doesn't work perfectly when the app has more sheets (say 20 or more). Additionally user is interested in having either radio buttons or hyperlinks, so just wondering if there is any way of achieving it using extensions.

Thanks

Shree

Re: Navigating to any sheet in Qliksense

Todd_Margolis — Wed, 20 May 2015 01:05:39 GMT

Another option is to turn the app into a web mashup. Then you can link to various sheets using html and javascript. For example, you easily could put each sheet on a tab using the jQuery UI tab widget. Or if you don't want to use jQuery or prefer not to use tabs, you can manually just set the CSS for the div containing each sheet (eg document.getElementById('sheet1').style.display = 'none'). Check out the workbench to quickly create the mashup.

Re: Navigating to any sheet in Qliksense

Anonymous — Wed, 20 May 2015 02:10:03 GMT

Yes, I meant this one.

Re: Navigating to any sheet in Qliksense

Wed, 20 May 2015 03:42:22 GMT

ok,

I just whipped this up. I think this is like what you are looking for. You will have to take on styling it and making it more useful, but I believe it will do what you want.

It's not pretty but it will create an extension object and show the list. You need to supply a dimension, but any dimension will do to make the sheet list render.

Re: Navigating to any sheet in Qliksense

Wed, 20 May 2015 17:11:12 GMT

Thanks much Jeffrey. This is what I was looking for.

Thanks

Shree

Re: Navigating to any sheet in Qliksense

Stefan_Walther — Thu, 21 May 2015 12:49:12 GMT

Hi,

currently what jog‌ is describing is the only way you can achieve the required functionality easily. We are looking into extending the Client APIs in a way which would allow you to jump to a specific sheet/next sheet etc. by just using a single API call. But as of now this is not part of the official APIs.

Regards

Stefan

Re: Navigating to any sheet in Qliksense

Thu, 21 May 2015 13:50:36 GMT

Hello all,

I cleaned this example up a bit and made it a dropdown list. In addition, a dimension is no longer required to make the visualization extension render properly. Just drag and drop and poof you will have a dropdown list of sheets in the app that when selected will navigate to that page.

Here is the link to the project on Branch: sheetList dropdown list extension

Re: Navigating to any sheet in Qliksense

Thu, 21 May 2015 16:48:25 GMT

Excellent. Thank you so much Jeffrey.

Thanks

Shree

Re: Navigating to any sheet in Qliksense

Fri, 22 May 2015 19:18:27 GMT

Hi Jeffrey,

One quick question. How can we know the name of the current sheet opened (e.g. value.qData.title gives the title of the sheets but want to know the title of the current sheet open). Idea is to avoid displaying that in the listbox/dropdown for navigation as it's already open.

Thanks

Shree

Re: Navigating to any sheet in Qliksense

Anonymous — Fri, 22 May 2015 20:03:54 GMT

It is in the upper right corner, to the right of "Edit" button. The sameI suggested to select sheets

Re: Navigating to any sheet in Qliksense

Fri, 22 May 2015 20:06:13 GMT

in the javascript, match the sheet id in the url to the value in the listbox and don't add it. Make it part of the $.each.

Re: Navigating to any sheet in Qliksense

Stefan_Walther — Tue, 13 Oct 2015 12:04:24 GMT

‌Hi,

have a look at https://github.com/stefanwalther/sense-navigation ...

Hope this helps and is what you were searching for ...

Regards

Stefan

Re: Navigating to any sheet in Qliksense

Wed, 06 Jan 2016 10:45:08 GMT

Hi Shree,

if you want navigate particular Sheet then you can use this function

paint: function ( $element, layout ) {

//add your rendering code here

function(){

qlik.navigation.gotoSheet('SheetID');

}

Regards,

Sai Madhu

Re: Navigating to any sheet in Qliksense

Fri, 08 Jan 2016 10:22:50 GMT

Hi Shree,

It is possible to navigate the sheets means one sheet to another sheet , using the sheetID then only it will be navigate

eg: qlik.navigation.gotoSheet('SheetID'); this method will be useful for navigate Specific sheet.

Thanks & Regards,

Sai Madhu

Re: Navigating to any sheet in Qliksense

Fri, 08 Jan 2016 10:29:15 GMT

Hi Shree,

If you want to get the sheetID goto the Hub http://localhost:4848/dev-hub/ and Click it the Single Configure and select particular App then its showing list of Sheet and then select any sheet , that particular sheetID display as Shown in bleow picture

Thanks & Regards,

Sai Madhu