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
Not exactly sure I understand your question but why dont you just connect the data in your script?
I am not that good with excel functions..can you elaborate what you are trying to do?
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
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
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
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
What are all the fields of interest in the table. Can you provide some sample data.
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.
See if attached helps..