Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
If your tables are linked on band then Qlik should automatically do that, it is the nature of the associative model.
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.
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
Yes, it is possible if you have a common key between those tables.
Make Band as a Key and try it.
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.
Can you share your datamodl
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
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?