topic Re: Setting 2nd Filter Based on 1st Filter in App Development

Setting 2nd Filter Based on 1st Filter

Charles_FMCC — Tue, 10 Aug 2021 20:20:33 GMT

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.

Re: Setting 2nd Filter Based on 1st Filter

stevejoyce — Tue, 10 Aug 2021 21:59:45 GMT

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)

Re: Setting 2nd Filter Based on 1st Filter

Charles_FMCC — Wed, 11 Aug 2021 10:53:06 GMT

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.