topic Lookup on two columns in QlikView https://community.qlik.com/t5/QlikView/Lookup-on-two-columns/m-p/753053#M667094 <HTML><HEAD></HEAD><BODY><P>Is it possible to&nbsp; use lookup function on two columns.</P><P>Can we concatenate those two columns and use that new alias to lookup</P></BODY></HTML> Fri, 14 Nov 2014 22:43:44 GMT 2014-11-14T22:43:44Z Lookup on two columns https://community.qlik.com/t5/QlikView/Lookup-on-two-columns/m-p/753053#M667094 <HTML><HEAD></HEAD><BODY><P>Is it possible to&nbsp; use lookup function on two columns.</P><P>Can we concatenate those two columns and use that new alias to lookup</P></BODY></HTML> Fri, 14 Nov 2014 22:43:44 GMT https://community.qlik.com/t5/QlikView/Lookup-on-two-columns/m-p/753053#M667094 2014-11-14T22:43:44Z Re: Lookup on two columns https://community.qlik.com/t5/QlikView/Lookup-on-two-columns/m-p/753054#M667095 <HTML><HEAD></HEAD><BODY><P>Yes, you have to concatenate two columns.</P><P></P><P>Lookup:</P><P>Load Country &amp; City As Key,Population Inline [</P><P>Country,City,Population</P><P>INDIA,MUMBAI,1C</P><P>INDIA,CHENNAI,.5C</P><P>INDIA,BANGALORE,.6C ];</P><P></P><P></P><P>State:</P><P>Load *,Lookup('Population','Key',Country &amp; City,'Lookup') As Pop&nbsp; Inline [</P><P>Country,State,City</P><P>INDIA,MH,MUMBAI</P><P>INDIA,TN,CHENNAI</P><P>INDIA,KA,BANGALORE ];</P></BODY></HTML> Sat, 15 Nov 2014 06:06:34 GMT https://community.qlik.com/t5/QlikView/Lookup-on-two-columns/m-p/753054#M667095 anbu1984 2014-11-15T06:06:34Z