Discussion Board for collaboration on QlikView Scripting.
I have two column A and B
A B C
1 a N/A2 1 1
3 c N/A
4 2 2
5 d N/A
Now i need to calculate a field C where it will check row wise like B column first row value is a, it will search a in full A column and if it finds the same value it should return a or else n/a.
PLEASE HELP ME ON THIS
Go to Solution.
I was able to accomplish this using the load script in the attached QVW.
this sounds like the sort of issue that ApplyMap could resolve.
To build your mapping table
Then user it like this
ApplyMap('MappingTable', B, 'N/A')
Steve Dark did a great blog post on ApplyMap - http://www.quickintelligence.co.uk/applymap-is-it-so-wrong/
Hi Marcus thanx a lot for your suggestion. It works fine