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 LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
mcmanus_peter
Contributor II
Contributor II

Vlookup function in Qlik sense

Hi,

I am trying to do a simply Vlookup function like in excel. I know there is a lookup etc, but where do I even enter this in order to do a lookup? Total new to Qlik Sense. In my head it should be easy but is Qlik Sense makes it so complicated. There is a reason behind me wanting to do this.

2 Replies
ThePeterK
Creator
Creator

I've been using 'firstsortedvalue' with set expressions to do my lookups. It's easy to get to and I'm not going into load scripts.

 

edit: Changed "Aggr" to "Set" expression

93/93