topic Re: Data Model in QlikView

Data Model

ankit777 — Thu, 24 Apr 2014 07:20:35 GMT

Hi All,

While creating a data model for an application and joining various tables, what should be preffered, LOOKUP or JOINS?

Can I know the pros and cons of using JOIN as well as LOOKUP?

MK_QSL — Thu, 24 Apr 2014 07:23:39 GMT

If there are

only two fields in a table ==> use Apply Map and Mapping Load

4-5 fields in a table==> use look up

more than 5 fields ==> use join...

But it still depends on your data model and requirements .... also, the number of lines in any table... etc..

ashfaq_haseeb — Thu, 24 Apr 2014 07:27:20 GMT

Hi,

Please find the below post from henric, Explaning the same

Hope it help.

Regards

ASHFAQ

its_anandrjs — Thu, 24 Apr 2014 07:32:11 GMT

Depends on the table nature and structure also it depends on the data model.

1. If there is unique key then use JOIN.

2. LOOKUP AND PEEK if want to load data from any location or read data or refer any field then use that one.

3. And free for all type of function.