How to use Vlookup in Qlik

[#1]

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.

[oknotsen]

You are correct. ApplyMap() is for looking up one value and returning one other.

If you need to match 1 field and add a bunch of fields to a table, I suggest using Join.

Combining tables with Join and Keep ‒ Qlik Sense

[Colin-Albert]

Yes, and no.

You can create as many mapping tables as you wish.

If you need to map 3 columns, create 3 mapping tables.

[#4]

Okay, thank you all. I figured this bit anyways.

I have another question I posted at Help with formula for prev. month & this month KPI.

Could any of you help me with that.

Thanks in advance.

[diptiharia]

Hi Siddharth,

Could you please share your solution on how you were able to figure our the 'vlookup' equivalent function?

Thanks!

Dipti

[TimmyCNHi]

After all those years, still no elegant Vlookup equivalent in Qlik Sense?