Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. $300 savings extended to February 9th Learn More
Highlighted
livio218526
Contributor

Inner join like vloockup excel

Hy Everyone,

It's possible use inner join on Qlik sense like a vloockup in Excel?

Tags (2)
3 Replies

Re: Inner join like vloockup excel

Maybe have a look at the Qlik ApplyMap() function

ApplyMap - script function ‒ Qlik Sense

livio218526
Contributor

Re: Inner join like vloockup excel

Yes I know that there is the function ApplyMap, but i'd like to import the tables and execute a inner join between it. I use inner join but i don't know if it's correct. In addiction, I have a lot of duplicates after the join and i want eliminate it, but how?

devarasu07
Honored Contributor II

Re: Inner join like vloockup excel

Hi,

applymap = excel vtlookup function. so just try to use mapping load with applymap

Apply Map in QlikView – Learn QlikView