Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Please see example below:
Data:
Oct | Nov |
abc,inc | abc,inc |
group.com | group.com |
hakdh.inc | hakdh.inc |
jdhd.ltd | zzzz.edu |
gsdj.ltd |
Analysis/result wanted
Oct | 5 |
dropped | 2 |
new | 1 |
nov | 4 |
I think the below attachment from Phaneendra addresses your issue.
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
The URL for the ApplyMap blog post is: http://www.quickintelligence.co.uk/applymap-is-it-so-wrong/