Skip to main content

Qlik Community

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Skip the ticket, Chat with Qlik Support instead for instant assistance.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
mcmanus_peter
Contributor II
Contributor II
‎2019-11-21 06:43 AM

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.

413 Views
2 Replies
ThePeterK
Creator
Creator
‎2019-11-21 01:37 PM

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
374 Views
0 Likes