Drilling on QlikSense (Server)

[#1]

I am new to QlikSense (server). How can we setup a app where a user can drill from a sheet1(rolled up data) to a sheet2(detail data) by clicking on a cell in one of the columns from sheet1? Is there a way to do something similar, alternate? any suggestion would be helpful. Thanks

[Michael_Tarallo · Accepted solution]

Hello Asif, for the record - if you are using Qlik Sense server, you may have a support contract and should be able to open a case by sending and email to support@qlik.com.

Qlik Sense does not have this capability available out of the box, but it may be possible to build it with an extension object. You can check out Qlik Branch at Qlik Branch - The Front Page -- and join and search the network and possibly make your request known there.

Note, there may be some sort of work-arounds to achieve this but some research would have to be done.

Here is an introduction to extension objects that may be helpful as well:

• http://community.qlik.com/docs/DOC-6932#mashups
• Qlik Sense - Introduction to Extensions (video)

Please mark the appropriate replies as helpful / correct so our team and other members know that your question(s) has been answered to your satisfaction.

Regards,

Mike Tarallo

Qlik

[#3]

Thanks Michael. We are using QlikSense Server!

I will look into the extensions. However, is there a alternate workflow you can suggest for someone who is expecting a drilling workflow in QlikSense Server?

[Michael_Tarallo]

Hi Asif, thanks for your question.

The one I can think of - is in an object coming in our next version that will allow you to link to a sheet, however it does not pass any parameters. It can show a aggregated value as a numeric text object - that you could link to a sheet that shows more detail - but it is not an actual drill from summary to detail with parameters. It simply links a sheet you choose to that object. You would then create the sheet to represent the detail from that summary.

Can you explain a bit more about your use case? - I would like to propose this to the Products team, but they would need to understand more about the requirement before considering etc.

Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.

Regards,

Mike Tarallo

Qlik

[#5]

the use case is very straight forward drill workflow. We have a rollup sheet1 that has couple of dimensions and some measures. User wants to click on one of the cells. in one of the dimension column and see detail data(in sheet2) that has the initial couple dimensions and few more.  The final sheet2 also should be filtered by the value of the cell the user clicked on the initial sheet.

it seems like the linking part wouldn't do the filtering part. is that correct?