topic Re: Keep & Join in QlikView

Keep & Join

Sun, 20 Sep 2015 02:41:02 GMT

Hi,

I have read at multiple places about keep and join functionality in qlikview.

They work exactly the same, except join prefix joins two table into one. My question is so when we should use keep and when we must use join.

Thanks in Advance

Regards

Priyanka

Chanty4u — Sun, 20 Sep 2015 03:36:15 GMT

Hi Priyanka,

Please follow the below link.

hope this clears your doubts

Thanks

Suresh Chanty

hic — Sun, 20 Sep 2015 10:39:52 GMT

A general rule is that you should join as little as possible. See To Join or not to Join.

You should look at "Keep" as an alternative to using "where Exists()".

HIC

Anonymous — Sun, 20 Sep 2015 11:03:01 GMT

hi priyanka,

please see below post: