Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
May 18th 10AM ET, Live Chat, bring your QlikView questions. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
raadwiptec
Creator II
Creator II

applymap

my source is something as below.

country  Marketing head

india        samson

france      ken

italy          rosh

india         patel

when i do an applymap.. i get for india only one value Ken and not th e other.. any suggestion

1 Solution

Accepted Solutions
raadwiptec
Creator II
Creator II
Author

guys this is fixed now... i tried loading as a seperate table itself with no concatenate..but applymap in pra ctical was not working...for the above scenario..

View solution in original post

12 Replies
sravanthialuval
Creator
Creator

Hi,

Please post sample script then we will let you know.

fvelascog72
Partner
Partner

Hi,

Maybe you need a left join, but you will duplicate registers.

Cheers

omkarvamsi
Creator
Creator

can you please elaborate a bit

stabben23
Master
Master

When you use applymap there should be distinct values from maptable, you have here 2 India, what do you expect for output when India is mapped?

terrorthijs
Partner
Partner

Applymap can only handle the translation of 1 input value to 1 output value, so this seems like a situation in which it shouldn't be used.

By the way: it would seem like for India the value would become Samson, not Ken?

fvelascog72
Partner
Partner

In attached file you can see the difference.

stabben23
Master
Master

A great example on why left join shouldn't be used. Increase sales on every salesman from india

raadwiptec
Creator II
Creator II
Author

iam expecting both samson and ken..

stabben23
Master
Master

, No you dont! Have a look at your data.