How to put Drill down in Qlik Sense.

[Anonymous]

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

[Anonymous]

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

[MK9885]

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.

[Anonymous]

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

[MK9885]

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

Make Band as a Key and try it.

[MK9885]

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]

Can you share your datamodl

[Anonymous]

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

[Anonymous]

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?