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!!

[robert_mika]

Search forum for Applymap

Don't join - use Applymap instead

[sunny_talwar]

I would do something like this:

Today() - ApplyMap('MappingTableName', FieldName) as Something

[#4]

Try with ApplyMap function.

[#5]

Hi there,

I think this may not be the right function for me.

What I am trying to do is:

IF task 1 is dependent on task 2, then check if task 2 is overdue. If it is, then make RAG status red.

If task 2 is dependent on task 3, and task 3 is overdue, then both task 2 and task 1 should become RED (as they're all dependent on one another)

Task	Due Date	Dependent on
Task 1	01/01/2016	Task 2
Task 2	01/03/2016	Task 3

[#6]

Hi there,

I'm struggling with this a little bit. Is it possible to show me an example of what this would look like using ApplyMap

=IF(Risk!A3="","",TODAY()-VLOOKUP(Risk!J3,Risk!A:L,11))

I am guessing that it would be using field names rather than Excel columns, so I've included that below:

=IF(Ref="","",TODAY()-VLOOKUP(Dependent,Ref,TargetDate))

Any help would be greatly appreciated

[amayuresh]

1. if you have two columns in source table and want to take value from second column then use ApplyMap() function.

2. if you have more than two column in source table and want to take value from any column from 2nd column then use lookup()

Second option is same vlookup() formula in excel, only parameter sequence is different.

[robert_mika]

Have you looked at the link provided?

See below

The first table (Ref) is your lookup table where T1 is your data for the lookup table

The second table (Orders or whatever you will call this table)is your table where you want to return your data

Ref:
     Mapping Load Dependent, TargetDate From T1 ;

The second step is to use this information when reading the order table, such as:

     Orders:
     Load *,

          Today()- ApplyMap('Ref', Dependent, null()) as Something
          From T2 ;

[#9]

Oh really, I can use the same vlookup?

What is the parameter diff?

[amayuresh]

Please refer this link for more details: LOAD data into QlikView