Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Lookup on two columns

Is it possible to  use lookup function on two columns.

Can we concatenate those two columns and use that new alias to lookup

Tags (1)
1 Reply
anbu1984
Honored Contributor III

Re: Lookup on two columns

Yes, you have to concatenate two columns.

Lookup:

Load Country & City As Key,Population Inline [

Country,City,Population

INDIA,MUMBAI,1C

INDIA,CHENNAI,.5C

INDIA,BANGALORE,.6C ];

State:

Load *,Lookup('Population','Key',Country & City,'Lookup') As Pop  Inline [

Country,State,City

INDIA,MH,MUMBAI

INDIA,TN,CHENNAI

INDIA,KA,BANGALORE ];

Community Browser