topic Re: question on joins and keep in QlikView

question on joins and keep

d_koti24 — Fri, 31 Oct 2014 03:43:39 GMT

Hi Guys,

i know the diff b/n join and keep,but my question is in which situation we go for join,and in which situation we for keep?

Regards,

koti

Re: question on joins and keep

Gysbert_Wassenaar — Fri, 31 Oct 2014 12:12:00 GMT

If you need to do calculations or comparisons in the script using fields from different tables then you'll first have to join the tables. In other cases you are free to decide if you'd rather have separate tables and use the keep function or want to consolidate tables using joins. There can be a difference in performance. That's something you'll have to test yourself since it depends very much on your specific data.

Re: question on joins and keep

its_anandrjs — Fri, 31 Oct 2014 12:20:39 GMT

Hi,

There are many reasons for using JOINs and KEEP depends on the user requirement.

1. Suppose you have two tables and this are big table and associated with key field but if you create single table it load once and give performance also.

2. Second there is one

table1: EmpNo,Salary and

table2: EmpNo, Commision, Address

but user wants EmpNo,Salary,Salary+Commision.

On chart it is ok to perform but if he needs to do some more calculation like top and bottom once then if it is in single table will be better.

It depends how it is used

Regards

Anand