Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

guruprem
Contributor III

How to drill through other reports in Qlik Sense

Hi,

In Qlik Sense while drilling down the information , is is possible to go into one more Qlik sense report and start analysisng. I mean, I wanna achieve similar functionality of Transfer State in Qlikview.

Regards

Guruprem

11 Replies
reddys310
Honored Contributor II

Re: How to drill through other reports in Qlik Sense

Hi Guruprem,

The transfer state option is not implicitly available in QlikSense. But you can navigate to an other report using the Text object and link the URL to it.Capture.png

If this does not fit your requirement, you can go with building an extension.

Hope this helps.

- Sangram

vadimtsushko
Contributor III

Re: How to drill through other reports in Qlik Sense

I believe you can go farther in that direction and provide sheet and selections in that (calculated) URL.

For example link below opens for me sheet `Sheepment` of sample application`Sales discovery` with period set to June 2013

http://localhost:4848/sense/app/C%3A%5CUsers%5CTsushko%5CDocuments%5CQlik%5CSense%5CApps%5CSales%20D...

See http://help.qlik.com/sense/2.1/en-us/developer/#../Subsystems/Mashups/Content/SingleIntegration/work...

for syntax details.

So it would be very close to QlikView's behaviour

Update: Actually text object support only static strings as URLs, so it's probably not possible to use calculated URL's with standard text object. So some sort of extension would be required anyway. Probably some of existing extensions would suite well for that purpose.

Well, all these static string properties will hurt you badly sooner or later in some scenario.

vadimtsushko
Contributor III

Re: How to drill through other reports in Qlik Sense

Actually I'm trying to reproduce that behaviour and can not do it for now.

Probably I was mistaken by some stored session data - maybe application remembered that selection and my calculated URL did not do anything at all. Though it seems to me very real at a moment

Probably that selection syntax do not apply when we open full application and not just single chart.

So probably as yet there is no easy way to do application chaining.

reddys310
Honored Contributor II

Re: How to drill through other reports in Qlik Sense

Hi Vadim,

URL's to access an object or a sheet is possible for sure as I am using it. As you have mentioned the selection or deeper document chaining might not apply.

guruprem
Contributor III

Re: How to drill through other reports in Qlik Sense

Thanks for your inputs, I think now the question reduced to "How to open Qlik Sense with pre-define selections ?". Your inputs please

Not applicable

Re: How to drill through other reports in Qlik Sense

I did this by creating a mashup in the Qlik Workbench.

Changed the .js file, to include an "Apply Bookmark" CASE in the

$( "[data-qcmd]" ).on( 'click', function () {
var $element = $( this );
switch ( $element.data( 'qcmd' ) ) {

//app level commands

switch. Just simply:

CASE 'applyBM':

     app.bookmark.apply( <bookmarkID> );

     break;

then calling it from a link like:

<a class="qcmd" data-qcmd="applyBM" href="<QlikSenseApplication>" target="_blank">

probably a cleaner way of doing it, but it works.

vadimtsushko
Contributor III

Re: How to drill through other reports in Qlik Sense

Actually I believe it can be done without creating mashup too.

You should use proper `Single Intergation API` URLs though (in my previous attempts I somehow assume that I can extend basic Qlik Sense URL with bits of Single Integration API and I was wrong).

With `Single Integration API` you can open the sheet of some other applicaiton with pre-defined selections.

So problem is separated to two parts:

1. How to create such URL dynamically based on selection in current application. That's more less trivial using QlikSense expressions.

2. How to open that URL. As I wrote above text object cannot support variables in it's link. So you should use some sort of extension, I've tried Sheet Navigation + Actions for Qlik Sense. and it works very well.

I hope to post about that with sample application soon.

guruprem
Contributor III

Re: How to drill through other reports in Qlik Sense

Vadim, You are approach excites me that we are close to a good solution. Let us try this method and share feedback here to conclude this discussion.

vadimtsushko
Contributor III

Re: How to drill through other reports in Qlik Sense

Look at these files for example: