<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Apply map - Key field is not unique **URGENT** in QlikView</title>
    <link>https://community.qlik.com/t5/QlikView/Apply-map-Key-field-is-not-unique-URGENT/m-p/903352#M1011814</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I have two QVD's one Item level and other at Header level.&lt;/P&gt;&lt;P&gt;I created a feild in Item level&amp;nbsp; with nested if statements, and trying to bring it into header level qvd thorugh apply map.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I see the records are copied over to header level but they doesn't seem right.&lt;/P&gt;&lt;P&gt;If i select the key field the values are correct&lt;/P&gt;&lt;P&gt;&lt;IMG __jive_id="85003" alt="Booking#.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/85003_Booking#.PNG" style="height: 190px; width: 620px;" /&gt;&lt;/P&gt;&lt;P&gt;but when i select the field i created(Tour Type) the values are messed up&lt;/P&gt;&lt;P&gt;&lt;IMG __jive_id="85016" alt="TourType.PNG" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/85016_TourType.PNG" style="height: 200px; width: 620px;" /&gt;&lt;/P&gt;&lt;P&gt;I see it is one-many relation in here.&lt;/P&gt;&lt;P&gt;I tried left join too.. no luck with that either.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I need this done asap..Can someone please help me how to get this right.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Thanks!&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Fri, 24 Apr 2015 14:48:37 GMT</pubDate>
    <dc:creator>Anonymous</dc:creator>
    <dc:date>2015-04-24T14:48:37Z</dc:date>
    <item>
      <title>Apply map - Key field is not unique **URGENT**</title>
      <link>https://community.qlik.com/t5/QlikView/Apply-map-Key-field-is-not-unique-URGENT/m-p/903352#M1011814</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I have two QVD's one Item level and other at Header level.&lt;/P&gt;&lt;P&gt;I created a feild in Item level&amp;nbsp; with nested if statements, and trying to bring it into header level qvd thorugh apply map.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I see the records are copied over to header level but they doesn't seem right.&lt;/P&gt;&lt;P&gt;If i select the key field the values are correct&lt;/P&gt;&lt;P&gt;&lt;IMG __jive_id="85003" alt="Booking#.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/85003_Booking#.PNG" style="height: 190px; width: 620px;" /&gt;&lt;/P&gt;&lt;P&gt;but when i select the field i created(Tour Type) the values are messed up&lt;/P&gt;&lt;P&gt;&lt;IMG __jive_id="85016" alt="TourType.PNG" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/85016_TourType.PNG" style="height: 200px; width: 620px;" /&gt;&lt;/P&gt;&lt;P&gt;I see it is one-many relation in here.&lt;/P&gt;&lt;P&gt;I tried left join too.. no luck with that either.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I need this done asap..Can someone please help me how to get this right.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Thanks!&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Fri, 24 Apr 2015 14:48:37 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/Apply-map-Key-field-is-not-unique-URGENT/m-p/903352#M1011814</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2015-04-24T14:48:37Z</dc:date>
    </item>
    <item>
      <title>Re: Apply map - Key field is not unique **URGENT**</title>
      <link>https://community.qlik.com/t5/QlikView/Apply-map-Key-field-is-not-unique-URGENT/m-p/903353#M1011815</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Can you post part of the script for your MAPPING table and the lookup for ApplyMap script.&lt;/P&gt;&lt;P&gt;Or simply post a sample file&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Fri, 24 Apr 2015 14:51:41 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/Apply-map-Key-field-is-not-unique-URGENT/m-p/903353#M1011815</guid>
      <dc:creator>Gabriel</dc:creator>
      <dc:date>2015-04-24T14:51:41Z</dc:date>
    </item>
    <item>
      <title>Re: Apply map - Key field is not unique **URGENT**</title>
      <link>https://community.qlik.com/t5/QlikView/Apply-map-Key-field-is-not-unique-URGENT/m-p/903354#M1011816</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Attached my qvw to the original post.&lt;/P&gt;&lt;P&gt;Please take a look&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Fri, 24 Apr 2015 14:58:48 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/Apply-map-Key-field-is-not-unique-URGENT/m-p/903354#M1011816</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2015-04-24T14:58:48Z</dc:date>
    </item>
  </channel>
</rss>

