VLookup

[#1]

Hey,

Does anyone know how to convert this Excel V-Lookup into a QV formula?

=TODAY()-(VLOOKUP(VLOOKUP(J2,A:L,10),A:L,11))

Thanks!!

[amayuresh · Accepted solution]

Examples:

Lookup:

ApplyMap():

[#3]

Thanks, I have a basic ApplyMap working. How would I do a nested ApplyMap?

Here is the working one

Today()- ApplyMap('Ref', Dependent, null()) as Dependency2

Here is the nested VLookup I'm trying to mirror

=IF(Ref="","",TODAY()-(VLOOKUP(VLOOKUP(Dependent,Risk!A:L,Dependent),Ref,TargetDate)))

I attempted with an nested ApplyMap but appear to have broken it

[amayuresh]

Please post sample data of both tables

[robert_mika]

What is the parameter diff?

Could you elaborate?

Feeling Qlikngry?

How To /Missing Manual(25 articles)

[robert_mika]

Post your formula.

[#7]

Hi,

Here is the nested formula I am trying, It has syntax errors, any ideas?

Today()- ApplyMap(ApplyMap('Ref', Dependent, null()), 'Ref', Dependent, null()) as Dependency1,

[#8]

I also tried this one:

Today()- ApplyMap('Ref',ApplyMap('Ref', Dependent, null()), Dependent, null()) as Dependency1,

[amayuresh]

Please check below is my example:

Script:

Output:

[Anonymous]

To create the temp table and resident the to the particular table it may be get the values.

[amayuresh]

As per your formula mentioned above (VLOOKUP(Dependent,Risk!A:L,Dependent)), you have more than two columns from source table so use lookup() function to get the target column value.