Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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