How to do vlookup in QV

[#1]

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

[Anonymous]

Not exactly sure I understand your question but why dont you just connect the data in your script?

[phaneendra_kunc]

I am not that good with excel functions..can you elaborate what you are trying to do?

[#4]

Hey Ruchi,

You can use applymap in script to do look ups.

Check out this post about applymaps : http://www.quickintelligence.co.uk/applymap-is-it-so-wrong/

Hope it helps.

Thanks

[#5]

Hi

I have list of customers in Oct and Nov. I want to find out how many customers

- were in OCt and not in NOV - dropped

- are in Nov and were not in OCt- New.

Please see below.

Oct	100
dropped	20
new	30
nov	110

In excel I used to do Vlook up, wondering how automate this in Qlikview.

Thank you

[#6]

You can use Set analysis on the front end. Something like this:

Count({<Month={'Nov'}>}Customers)  Count of Customers for only Nov

Count({<Month={'Oct'}>}Customers)  Count of Customers for only Oct

[#7]

I don't have to count, I have to match each field value in oct to each value in november and see oif there is a match or not

[#8]

What are all the fields of interest in the table. Can you provide some sample data.

[#9]

There is actually a function called Lookup in Qlikview.

Check out this post: http://community.qlik.com/docs/DOC-3903

It has a great example.

Hope it points you in the right direction.

[phaneendra_kunc]

See if attached helps..