8 Replies Latest reply: Dec 11, 2016 1:32 PM by Bella Mae RSS

    How to put Drill down in Qlik Sense.

    Anirban Mitra

      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

        • Re: How to put Drill down in Qlik Sense.
          Bella Mae

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

          • Re: How to put Drill down in Qlik Sense.
            Aehman K

            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.

            • Re: How to put Drill down in Qlik Sense.
              Anirban Mitra

              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

              • Re: How to put Drill down in Qlik Sense.
                Anirban Mitra

                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