Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
ani310_mitra
New Contributor III

How to put Drill down in Qlik Sense.

Hi,

I have a requirement to link 2 reports in qlik sense.

For example-

I have one report like below

Band     Count

---------     ----------

B1          1

B2          2

B3          3

I have one more report like below--

Band     Employee

---------     --------------

B1             B1001

B2             B1002

B2             B1003

B3             B1004

B3             B1005

B3             B1006

Now my requirement is to link above 2 reports. If I click on value 1 in First report then it should show me only B1 in second report, Similarly for other band also.

Is it possible to do in Qlik Sense? If possible could you please let me know how we can achieve this.

Thanks

Anirban

8 Replies
bellamae
Valued Contributor

Re: How to put Drill down in Qlik Sense.

If your tables are linked on band then Qlik should automatically do that, it is the nature of the associative model.

Khan_Mohammed
Honored Contributor II

Re: How to put Drill down in Qlik Sense.

Band     Count

---------     ----------

B1          1

B2          2

B3          3

Band     Employee

---------     --------------

B1             B1001

B2             B1002

B2             B1003

B3             B1004

B3             B1005

B3             B1006

This tables will automatically concatenate or Make a Key

If you concatenate it then you'll get below view.

Band     Employee       Count

---------     --------------     -----------

B1             B1001          1

B2             B1002          2

B2             B1003          2

B3             B1004          3

B3             B1005          3

B3             B1006          3

If you looking for Drill Down option, you need to add your Dimensions to Master Items in Sense to use it as Drill Down.

ani310_mitra
New Contributor III

Re: How to put Drill down in Qlik Sense.

Hi Bella and Arvind,

Thank you very much for your reply, but my requirement is to show drill down report.

Suppose for the first table if I click on 1 beside BU1 (which is basically headcount in BU1), it should show all the attribute of that particular employee.

Is it possible??

Thanks

Anirban

Khan_Mohammed
Honored Contributor II

Re: How to put Drill down in Qlik Sense.

Yes, it is possible if you have a common key between those tables.

Make Band as a Key and try it.

Khan_Mohammed
Honored Contributor II

Re: How to put Drill down in Qlik Sense.

I've attached a test qvf.

Your tables will get automatically concatenated as you've common field 'Band'

For drill down, you should add it in Master Items.

Thanks.

rupamjyotidas
Valued Contributor

Re: How to put Drill down in Qlik Sense.

Can you share your datamodl

ani310_mitra
New Contributor III

Re: How to put Drill down in Qlik Sense.

Hi All,

Thank you for your reply.

My requirement is

I have 2 table--

First table--

Band     Emp count

B1          1

B2           2

second table-

EmpID     Band     Region

1001          B1          R1

1002          B2          R2

1003          B2          R2

I have created 2 report which display report from first table and 2nd report from 2nd table.

Now user will click on 1 in first report, it should go to second report with filter as B1. So I have to connect 2 report.

Please let me know whether it is possible to do so.

Thanks

Anirban

bellamae
Valued Contributor

Re: How to put Drill down in Qlik Sense.

Firstly

a) are your data tables linked by the field band?

b) are both you tables on the same sheet?

c) what is happening when you select something in table 1?

d) what do you expect to happen? are you wanting the second table to just be limited or are you look for a hyperlink to a second sheet?