3 Replies Latest reply: Jul 16, 2017 11:47 PM by Fei Xu RSS

    How to create a drill down column which doesn’t exist in original data

    Ivan Yang

      Dear Qlik Sense Expert

       

      I am new to QS and I have a question for drill down

       

      Now I have a table as below and I need to create 2 drill down indicators in Qlik Sense which are ‘A’ & ‘B’

       

      ‘A’ & ‘B’ don’t exist in any column of original data


      1.PNG

      The visualization I need is as below.

      - When I click ‘A’, which is the indicator we create in the previous step, the pie will drill down to ‘A1’ ’A2’ ’A3’ ’A4’.

      - When I click ‘B’, which is the indicator we create in the previous step, the pie will drill down to ‘B1’ ’B2’.

      - ‘C’ is the indicator which exists in the original data


      2.PNG


      May I know if its workable in Qlik Sense? If so, how to accomplish it?

       

      Thank you for your advise in advance

       

      Ivan