Please read the below tips for posting things in the forum. I would recommend that you check your spelling in the subject line if you wish to get good answers.
Why do you use join in QlikView or Qlik Sense? For the same reason as you do it in every serious BI solution:
Less tables = higher performance.
Yes, QlikView can handle a normalized data model, as long as there is not too much data in there. Once you start running into performance problems, optimization of your data model is the first thing to do.
Please do some investigation about star-models in BI solutions.
We may use join in the script to combine two (or more) tables into one. Why - usually to optimize the data model. (That doesn't mean of course that any join makes your data model better.)
.png "Former Employee"){kind=icon}
