Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

help in data modeling

Hi All,

I have two fact tables and 5 dimension tables. Fact tables should not be linked. What is the better approach to design the data model?

As of now, I have designed by joining the dimension tales to fact tables. But in the application, I have charts from both fact tables and filters from dimension tables. Now the problem is I have to pass the dimension filed selections to respective fields to both the fact tables since the fact tables are connected, could anyone guide me on this?

Regards,
Shruthi

1 Reply
Highlighted
Partner
Partner

Hi Shruthi,

As per My thought process you need to add link table.

For more detail please provide sample data in excel .

Thanks & Regards,

Arvind Patil