Can you get Qlikview to run an If statement with a Vlookup

[rsapaull]

Hi all,

Am quite new to Qlikview, and I'm trying to build something where qlikview would need to create a new date column based on criteria and information from 2 different tables.  I currently do this in excel using the following formula:

=IF((VLOOKUP(G2,Lookup!$B$4:$C$13,2,FALSE))="yes",I2,IF((VLOOKUP(G2,Lookup!$B$4:$C$13,2,FALSE))="no",J2+1,"check"))

Is this possible or is it something that would need to be done separately in excel?

To put things into context, G is the definition of what is happening to the order, I is the purchase date, and J is the delivery estimate.  The lookup table has Yes or No depending on the definition of what is happening to the order.

[gautik92 · Accepted solution]

for vlookup you can use applymap() statement in qlikview

[hic]

You can do this in the script by using Applymap() or Lookup(). See more in Joins and Lookups

HIC

[Gabriel]

Hi,

Suggestions above will work but if you can post (Attach) sample data then you will be sure to have more precise reply.

[Peter_Cammaert]

If the tables are correctly connected in your QlikView data model, you could use something like:

=If (IsNull([OrderInProgress]), 'check', pick(match([OrderInProgress], 'yes', 'no'), [PurchaseDate], [DeliveryEstimate]))

The new [OrderInProgress] field contains you original VLOOKUP value that is linked to some/most of the Orders. You can either JOIN this value to the Orders table (preferred), or keep it in a separate table linked to the Orders table.