Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
debsahoo
Contributor III
Contributor III

Which is faster between join and keep

>For load script  which is faster between Join and keep? why?

>For dashboard which is faster? why?

Thanks in advance.

10 Replies
marcus_sommer

Although the mechanism of action is quite similar the common use-cases are different. A "classical" join is aimed to add further informations to an existing table and a keep-statement will keep both of the used tables and filter them in a certain way. A use-case for keep could be to filter a dimension-table (for example products) to the products from the sales fact-table.

- Marcus