1 Reply Latest reply: Jul 17, 2017 5:53 AM by Agostino Cardella RSS

    How to display member and its sub member when selecting a member in the filter pane

    Susan Liu

      I am new for qlik sense. I have two tables A and B. A is a table including all of members. B is a subsidiary table.B include two columns, one is member, the other one is subsidiary member. For example

       

      Table A

      -------------------------------------------

      cust_no  shipment     paid_amt

      aa           1                 50.00

      bb           2                 20.00

       

       

      Table B

      --------------------------------------------

      cust_no     subsidiary_no

      aa              aa

      aa              bb

       

      The result I want is when I select aa in filter pane, it show aa and bb.

      Thanks,