Dynamic Data Table

Mon, 10 Feb 2014 12:46:58 GMT

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.

Thanks for any suggestions

Re: Dynamic Data Table

Mon, 10 Feb 2014 13:23:04 GMT

May I suggest you to read the following doc: it may help you

Fabrice

Dynamic Tables and Graphs

topic Dynamic Data Table in QlikView

Dynamic Data Table

Re: Dynamic Data Table