topic Re: jion in QlikView

Join question

maniram23 — Sun, 19 Apr 2015 05:10:34 GMT

why we are using join in data model?

Re: jion

Mattias_Malré — Mon, 20 Apr 2015 07:10:56 GMT

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.

https://community.qlik.com/docs/DOC-7538

All the best

-Mattias

Re: jion

Agis-Kalogiannis — Mon, 20 Apr 2015 09:47:02 GMT

To Join two tables so as to optimise the performance of our QlikView data model

Re: jion

oknotsen — Mon, 20 Apr 2015 12:25:42 GMT

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.

Re: jion

Anonymous — Mon, 20 Apr 2015 12:31:38 GMT

We are not using join in data model.

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.)