<?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 PROBLEM TO CORRECTLY FORMAT A QLIK TABLE in QlikView</title>
    <link>https://community.qlik.com/t5/QlikView/PROBLEM-TO-CORRECTLY-FORMAT-A-QLIK-TABLE/m-p/1531910#M747161</link>
    <description>&lt;DIV class="topic-subject-wrapper"&gt;&lt;DIV class="lia-message-subject lia-component-message-view-widget-subject"&gt;&lt;DIV class="MessageSubject"&gt;&lt;P&gt;Hi,&lt;/P&gt;&lt;P&gt;&lt;SPAN&gt;I apologize first of all if I ask for elementary things.&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN&gt;I have a articulate oracle database that contain a lot of information...I had to extract many fields from xml and other from a specific view ...i have a primary key named IDREFERTO&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN&gt;The&amp;nbsp;script created gives me all the information necessary to calculate what i want...but i have a lot of problems to create a specific table in qlik that give me all the information aggregate&amp;nbsp; under my primary key.&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;Currently I have a table that provides in output the results as shown&lt;SPAN&gt;n in the attached file HAEMODEXAMPLE.qvw...in wich you can see that there are replicated field (es.material or pharma).&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN&gt;My first goal is to obtain a table that for a single primary key (IDREFERTO) could have more than one&amp;nbsp;row for the other values ​​preloaded via script like the example in excel.&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN&gt;Is it possible?&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN&gt;I must change the script or there are some qlik function or graphic configuration that i can utilize to format correctly the table?&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;/DIV&gt;&lt;/DIV&gt;&lt;/DIV&gt;&lt;DIV class="lia-message-body lia-component-body-signature-highlight-escalation"&gt;&lt;DIV class="lia-message-body-content"&gt;&lt;P&gt;&lt;SPAN&gt;Regards&lt;/SPAN&gt;&lt;/P&gt;&lt;/DIV&gt;&lt;/DIV&gt;</description>
    <pubDate>Wed, 25 Nov 2020 16:16:04 GMT</pubDate>
    <dc:creator>gabroteddy</dc:creator>
    <dc:date>2020-11-25T16:16:04Z</dc:date>
    <item>
      <title>PROBLEM TO CORRECTLY FORMAT A QLIK TABLE</title>
      <link>https://community.qlik.com/t5/QlikView/PROBLEM-TO-CORRECTLY-FORMAT-A-QLIK-TABLE/m-p/1531910#M747161</link>
      <description>&lt;DIV class="topic-subject-wrapper"&gt;&lt;DIV class="lia-message-subject lia-component-message-view-widget-subject"&gt;&lt;DIV class="MessageSubject"&gt;&lt;P&gt;Hi,&lt;/P&gt;&lt;P&gt;&lt;SPAN&gt;I apologize first of all if I ask for elementary things.&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN&gt;I have a articulate oracle database that contain a lot of information...I had to extract many fields from xml and other from a specific view ...i have a primary key named IDREFERTO&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN&gt;The&amp;nbsp;script created gives me all the information necessary to calculate what i want...but i have a lot of problems to create a specific table in qlik that give me all the information aggregate&amp;nbsp; under my primary key.&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;Currently I have a table that provides in output the results as shown&lt;SPAN&gt;n in the attached file HAEMODEXAMPLE.qvw...in wich you can see that there are replicated field (es.material or pharma).&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN&gt;My first goal is to obtain a table that for a single primary key (IDREFERTO) could have more than one&amp;nbsp;row for the other values ​​preloaded via script like the example in excel.&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN&gt;Is it possible?&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN&gt;I must change the script or there are some qlik function or graphic configuration that i can utilize to format correctly the table?&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;/DIV&gt;&lt;/DIV&gt;&lt;/DIV&gt;&lt;DIV class="lia-message-body lia-component-body-signature-highlight-escalation"&gt;&lt;DIV class="lia-message-body-content"&gt;&lt;P&gt;&lt;SPAN&gt;Regards&lt;/SPAN&gt;&lt;/P&gt;&lt;/DIV&gt;&lt;/DIV&gt;</description>
      <pubDate>Wed, 25 Nov 2020 16:16:04 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/PROBLEM-TO-CORRECTLY-FORMAT-A-QLIK-TABLE/m-p/1531910#M747161</guid>
      <dc:creator>gabroteddy</dc:creator>
      <dc:date>2020-11-25T16:16:04Z</dc:date>
    </item>
  </channel>
</rss>

