Hi,
I have a QlikApp that contains multiple tables. Some of these tables contain a Fiscal Year dimension, some do not, but all tables have some form of date dimension, whether that be an accounting month (YYYYMM) or pay period end date (MMDDYYYY).
I want to be able to filter by fiscal year and have the tables that don't have fiscal year dimensions filter to the selected fiscal year. For example, if I select FY2018, I want all pay period end dates to filter to FY2018 even though that table doesn't have FY built in. I think it should be able to do this as all pay period end dates contain the years of the pay periods.
Can someone tell me how to make this work?
Thank you!