Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to do vlookup in QV

Hi

I have same fields of data for two differnt months and want to do vlookup in Qv.

Is it possible? - at querry or dashboard level?

Thank you much in advance for your response.

Ruchi

13 Replies
Not applicable
Author

Hi Please see example below:

Data:

OctNov
abc,incabc,inc
group.comgroup.com
hakdh.inchakdh.inc
jdhd.ltdzzzz.edu
gsdj.ltd

Analysis/result wanted

Oct 5
dropped2
new 1
nov4


Not applicable
Author

I think the below attachment from Phaneendra addresses your issue.

stevedark
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi there,

The closes comparable feature to an Excel VLookup in QlikView is the ApplyMap statement.  It allows you to load data from one source and map it on to another.  Extra parameters allow you to work some magic with it.

I have a blog post on Apply Maps, on the Quick Intelligence web site.  I shall post a link to it below.

Steve

stevedark
Partner Ambassador/MVP
Partner Ambassador/MVP

The URL for the ApplyMap blog post is: http://www.quickintelligence.co.uk/applymap-is-it-so-wrong/