In my QlikView Dashboard I only have two tabs. The Second one is hidden until the user clicks on which Data Analytic they want to go to.
In Summary Page, I have a datatable with 10 rows of Data that correlate to a particular TEST_ID. Numbered 1-10. I have TEST_ID triggered to launch 2nd sheet and automatically filters which TEST_ID I clicked on. All of my text boxes and Charts are all automated to that specific Test except the Datatable displaying the details for this TEST_ID.
Tables: (for this example i am only staying to TEST_ID =1)
SCRA_Main (Main Table that has General Account Information for all 10 Tests)
SCRA_04_Fees_Assessed: (Has specific account information about fees)
I set up the Relationships to tie to the TEST_ID by:
TESTLOAN:
LOAD DISTINCT 1 As TEST_ID,
ACCOUNT_NBR FROM $(qvdPath)VW_A004.qvd(qvd)
Then All tables are Linked by ACCOUNT_NBR and TEST_ID, so it automatically filters to TEST_ID =1.
I am trying to make a dynamic DataTable that will take all columns from Main & Dynamically add the all columns from the table that I click on each TEST. Otherwise, this will be the only part of this entire sheet that i have to hardcode 10 data tables and add each TEST Table columns manually.
