Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

How to use Vlookup in Qlik

Hi All,

I am relatively new to Qlik Sense.

I wanted to know how to use Vlookup in Qlik Sense. I have associated the two tables but am not finding a way to perform Vlookup.

I have attached the snippet of how my table is Modeled. I need the highlighted column of Num_Of_TS-Entries_per_day into a calculated column in Busyness table.

If anyone is familiar with Power Pivot, I am looking for a =RELATED() equivalent.

Tags (1)
13 Replies
sureshqv
Esteemed Contributor III

Re: How to use Vlookup in Qlik

Not applicable

Re: How to use Vlookup in Qlik

Thanks but this looks like Qlik View, I need it for Qlik Sense.

MVP
MVP

Re: How to use Vlookup in Qlik

I guess you need Applymap(). Explore this function from Help: ApplyMap - script function ‒ Qlik Sense

Re: How to use Vlookup in Qlik

The data is already associate according to your data model, so you should be able to count the number of entries per day without changing your model.

If you do want to alter the model, the equivalent of VLookup is to use a "Mapping Load" and "ApplyMap" which you can add in your load script.

These posts relate to QlikView but the command syntax is identical.

Don't join - use Applymap instead

http://www.quickintelligence.co.uk/applymap-is-it-so-wrong/

Not applicable

Re: How to use Vlookup in Qlik

Okay, newbie question I guess, I have to use applymap while loading right? I cant use it as a Calculated Field (which is what I actually want). This calculation has to take place after it is loaded.

reddys310
Honored Contributor II

Re: How to use Vlookup in Qlik

Hi Siddharth,

You can make use of applymap() or Lookup(). You can even check out Left Keep() which ever fits your cause best.

Thanks,

Sangram.

Not applicable

Re: How to use Vlookup in Qlik

No, does not help. Anyways, I found a work around. Thanks guys.

Re: How to use Vlookup in Qlik

Applymap is used in the script when loading data, it cannot be used as a chart expression.

Not applicable

Re: How to use Vlookup in Qlik

Also looks like I cannot use Applymap if I have more than 2 columns.