Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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,

1 Reply
acardella
Partner - Creator
Partner - Creator

Hi Liu.

by the column name Qlik have already linked you information about CUST_NO and SUBSIDIARY_NO.

So you need only to add the "SUBSIDIARY_NO" dimension to an appropriate visualization that show, for example, SUM(paid_amt) as expression.


Bye