Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
acarrera
Partner
Partner

Lookup() vs. Join Performance, ApplyMap() vs. Inner Join

Hi all,

I am replacing some Joins with ApplyMap() and (potentially) Lookup() in a Qlik Sense script.

Two questions:

  1. I know ApplyMap() is faster than Lookup() and joining, but is Lookup() faster than a join too?
  2. Can I use ApplyMap() with Where Exists() to simulate an inner join?

 

Thanks,

Alex

Labels (6)
1 Solution

Accepted Solutions
rwunderlich

Lookup is likely the slowest option. See https://qlikviewcookbook.com/2020/03/creating-temporary-script-associations/.

Yes, you can use ApplyMap with Where Exists to replace an inner join. 

-Rob

View solution in original post

2 Replies
rwunderlich

Lookup is likely the slowest option. See https://qlikviewcookbook.com/2020/03/creating-temporary-script-associations/.

Yes, you can use ApplyMap with Where Exists to replace an inner join. 

-Rob

View solution in original post

acarrera
Partner
Partner
Author

Great, thanks Rob for your prompt and informative reply!

Best,

Alex