topic Mapping load and Apply Map in QlikView

Mapping load and Apply Map

Thu, 04 Jul 2013 08:17:14 GMT

Hi All,

Will mapping load and Apply Map work when there is many to many relation between two keys. As per my understanding it wont work or result set will be wrong.

please let me know the workaround for this.

Thanks in Advance.

Homprakash.

Re: Mapping load and Apply Map

er_mohit — Thu, 04 Jul 2013 09:20:56 GMT

See the attached file

Re: Mapping load and Apply Map

hic — Thu, 04 Jul 2013 09:27:50 GMT

You cannot use Applymap() for many-to-many relations. The function demands that there is only one translation (mapped value) to the input value. But you can of course have several different input values that all are mapped to the same translation.

When creating the mapping table, QlikView will only pick up the first occurance of an input value, thus ensuring that there is no ambiguity.

HIC