Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
transalp89
Contributor
Contributor

How to get a value (equivalent vlookup in excel)

I have a list of product. for each product I have a plan start  and the actual date for several process.

Depending some rules, I invoice the product at different stage of the process.

I want to create a table with the plan invoice date.

in joined excel sheet I putan example

sheet process with product/process and date for planned and actual

sheet Rules Product/ rule

sheet result is the wanted result.

I have try to use peek functiun without success

If you can help me it will be great !!

Thanks in advance !

2 Replies
PradeepReddy
Specialist II
Specialist II

see the attachment, it might be helpful...

Not applicable

You can use Lookup function or ApplyMap method to achieve vlookup.