Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Kohli
Creator II
Creator II

why we use keep instead of Joins?

In Joins and Keeps we will get same output. But why we have to use Keep?

1 Reply
petter
Partner - Champion III
Partner - Champion III

Please have a closer look at the documentation as it is very clear about the benefits of KEEP versus JOIN:

- One of the main features of Qlik Sense is its ability to make associations between multiple tables instead of joining them, which greatly reduces memory usage, increases processing speed and offers enormous flexibility. Explicit joins should therefore generally be avoided in Qlik Sense scripts. The keep functionality was designed to reduce the number of cases where explicit joins needs to be used.


https://help.qlik.com/en-US/sense/September2018/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptPre...