Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

Joining multiple tables - Best Practice

Hi Experts - Need your opinion what is the best practice when we join multiple tables (more than 5 tables) in qlikview? I mean, By which we should join and by which we should not join... like those things... Bcoz am getting confused sometimes due these... Appreciate your explanation on this..

Tags (3)
7 Replies
Highlighted
Specialist II
Specialist II

Re: Joining multiple tables - Best Practice

Highlighted

Re: Joining multiple tables - Best Practice

It depends on your requirement or data model but when you join to table then the base is Keys / Primary keys / composite keys and while you concatenate more fields same or all fields same.

Some Qlikview Joins,Keep,Concatenation and Applymap best documents

Qlikview

Highlighted
Master II
Master II

Re: Joining multiple tables - Best Practice

Hi Bharani,

Read these two from an expert and i hope it is more appropriate for your question To Join or not to Join and Don't join - use Applymap instead

-Siva

Highlighted
Creator III
Creator III

Re: Joining multiple tables - Best Practice

Thank you All for taking ur time to respond on this!! Appreciated!!

Highlighted

Re: Joining multiple tables - Best Practice

Even this is the best

Star Schema or Snow Flaxe schema?

Highlighted
Master II
Master II

Re: Joining multiple tables - Best Practice

Though there are many recommendations, I suggest you to join first two tables and check the data for any duplicates or missing values and then join by adding third table, 4th and 5th and so on.

This way you will make sure that all the necessary data are loaded properly.

-Siva