topic Re: How to create dynamic table reference in QlikView

How to create dynamic table reference

Anonymous — Sat, 27 Dec 2014 11:43:27 GMT

Hi All,

I have a fact table and various Dimension tables. Please find attached files for model reference.

I want to have a dynamic environment where my Drilldown values(Tables and fields to be looked up) from Fact are picked and as a reference from Dim_Drilldown tables.

Then refer the Dim_Entity or Dim_Description table and find appropriate values from it via joins.

Incase if more clarification is required then please let me know.

Wish you a Merry Christmas and Happy New year !!

Re: How to create dynamic table reference

prieper — Sat, 27 Dec 2014 20:31:34 GMT

The dynamic is inside the QV-logic, i.e. selected fields are green, possible white and not avail in gray.

Can you describe a bit more precise, please?

Peter

Re: How to create dynamic table reference

Anonymous — Tue, 30 Dec 2014 13:00:27 GMT

Hi Peter ,

On basis of Dim_Drilldown The table should looked up. Dim_Drilldown has information of which table to be looked up and which column data to be picked. Refer attached image.

The tables data should look up dynamically or be mapped accordingly to pick the right data.

Thanks in Advance

Wish You happy new year !!

Re: How to create dynamic table reference

Anonymous — Thu, 15 Jan 2015 10:56:26 GMT

gwassenaar swuehl

Legends, I will be obliged for the help !!