Discussion board where members can get started with Qlik Sense.
I have a requirement to link 2 reports in qlik sense.
I have one report like below
I have one more report like below--
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.
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??
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.
Thank you for your reply.
My requirement is
I have 2 table--
Band Emp count
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.
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?