Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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
New Contributor III

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

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