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: 
Charles_FMCC
Contributor II
Contributor II

Setting 2nd Filter Based on 1st Filter

I have 2 tables, Table A and Table B.  I have a selection filter for date on Table A.  I have a straight table based on Table A and want to add a straight based on Table B = Table A date.  I tried the following as an example and have not been able to get the second table to populate or it does not filter.

No results saying calculation condition unfulfilled:

vTableA_EFF = TableA.EFF_DT

TableB.EFF_DT = $(vTableA_EFF)

 

Second attempt shows all records in Table B:

TableB.EFF_DT = $(TableA.EFF_DT)

 

Any insight into what would be a good way to make this happen.  I am unable to use macros due to company constraints.

2 Replies
stevejoyce
Specialist II
Specialist II

Not sure how those variables are being used, your set analysis?

You can make your expressions use for example:  Sum({<TableB.EFF_DT=P(TableA.EFF_DT)>}  Measure)

Charles_FMCC
Contributor II
Contributor II
Author

Basically I select a date in a List box for Table A and generate a straight table based on it.  Without having to add a second date List box for Table B, I want to add another straight table base on Table B and the same date.