<?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 Re: Qlik sense initial load all data seems to corrupt selection in Integration, Extension &amp; APIs</title>
    <link>https://community.qlik.com/t5/Integration-Extension-APIs/Qlik-sense-initial-load-all-data-seems-to-corrupt-selection/m-p/862230#M2939</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi Bryan,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Do you resolved this issue?&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Thanks,&lt;/P&gt;&lt;P&gt;André Silva&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Wed, 11 Oct 2017 17:48:52 GMT</pubDate>
    <dc:creator>Anonymous</dc:creator>
    <dc:date>2017-10-11T17:48:52Z</dc:date>
    <item>
      <title>Qlik sense initial load all data seems to corrupt selection</title>
      <link>https://community.qlik.com/t5/Integration-Extension-APIs/Qlik-sense-initial-load-all-data-seems-to-corrupt-selection/m-p/862229#M2938</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hello guys,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I was recently trying to load 800+ records into my application for demo purposes.&lt;/P&gt;&lt;P&gt;I know eventually my client would need to load 20000+ records which has exceeded the qlik sense limit of 10000 cell data.&lt;/P&gt;&lt;P&gt;As such I was reading through the following articles to aid my situation.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;A href="https://community.qlik.com/thread/131776"&gt;How do I use getData in an Extension object?&lt;/A&gt;&lt;/P&gt;&lt;P&gt;&lt;A href="https://help.qlik.com/sense/en-US/developer/#../Subsystems/Workbench/Content/BuildingExtensions/API/backendApi/getdata-method.htm%3FTocPath%3DQlik%2520Sense%2520Workbench%7CAPI%2520reference%7CQlik%2520Sense%2520Backend%2520API%2520reference%7C_____7" title="https://help.qlik.com/sense/en-US/developer/#../Subsystems/Workbench/Content/BuildingExtensions/API/backendApi/getdata-method.htm%3FTocPath%3DQlik%2520Sense%2520Workbench%7CAPI%2520reference%7CQlik%2520Sense%2520Backend%2520API%2520reference%7C_____7"&gt;https://help.qlik.com/sense/en-US/developer/#../Subsystems/Workbench/Content/BuildingExtensions/API/backendApi/getdata-m…&lt;/A&gt;‌&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;While the data does get loaded initially, I does realised if I fool around with the current selection by selecting and deselecting values, eventually the backendApi would mix up and instead of retrieving the correct set of say for example 500 records, they retrieve 450 correct records and 50 duplicated records.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I know it's a little difficult to understand so I have attach the necessary files to replicate the issue for anyone who wish to try out.&lt;/P&gt;&lt;P&gt;In the sample, there is an qvf application that load the extension, the extension that will produce the behavior, a sample data file that is preloaded into the app and finally a screenshot of the duplicate I been mentioning.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;To replicate, after loading the application in qlik sense, preferably launch it via browser such as chrome using&lt;/P&gt;&lt;P&gt;&lt;A class="jive-link-external-small" href="http://localhost:4848/hub" rel="nofollow"&gt;http://localhost:4848/hub&lt;/A&gt;&lt;SPAN&gt; and activate the developer tool.&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Once there, there are 2 panels, extension is on the left and a table is on the right.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Simply select any value in VALUE2 column to start populating qlik sense current selection bar.&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 10pt; line-height: 1.5em;"&gt;Then from the selection bar, g&lt;/SPAN&gt;&lt;SPAN style="font-size: 10pt; line-height: 1.5em;"&gt;o ahead and select all the values for VALUE2.&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 10pt; line-height: 1.5em;"&gt;Now try to reduce them one by one.&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 10pt; line-height: 1.5em;"&gt;Then add them back one by one.&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 10pt; line-height: 1.5em;"&gt;You should be able to replicate the problem when the developer console is showing "duplicate - xxxxxxxxxx".&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 10pt; line-height: 1.5em;"&gt;&lt;BR /&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 10pt; line-height: 1.5em;"&gt;These "duplicate - &lt;SPAN style="font-size: 13.3333330154419px;"&gt;xxxxxxxxxx&lt;/SPAN&gt;" are the mentioned records that is duplicated and are replacing my actual selection data.&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 10pt; line-height: 1.5em;"&gt;As such, layout.qHyperCube.qDataPages[0].qMatrix is not returning me my complete set of data.&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 10pt; line-height: 1.5em;"&gt;&lt;BR /&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 10pt; line-height: 1.5em;"&gt;Would totally appreciate some help on this matter, thanks!&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 10pt; line-height: 1.5em;"&gt;&lt;BR /&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 10pt; line-height: 1.5em;"&gt;P.S. The solution works perfectly when I set the read size to be 1000 rather than 20.&lt;BR /&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 10pt; line-height: 1.5em;"&gt;&lt;BR /&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Fri, 19 Jun 2015 11:54:35 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Integration-Extension-APIs/Qlik-sense-initial-load-all-data-seems-to-corrupt-selection/m-p/862229#M2938</guid>
      <dc:creator>bryan_sng</dc:creator>
      <dc:date>2015-06-19T11:54:35Z</dc:date>
    </item>
    <item>
      <title>Re: Qlik sense initial load all data seems to corrupt selection</title>
      <link>https://community.qlik.com/t5/Integration-Extension-APIs/Qlik-sense-initial-load-all-data-seems-to-corrupt-selection/m-p/862230#M2939</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi Bryan,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Do you resolved this issue?&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Thanks,&lt;/P&gt;&lt;P&gt;André Silva&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 11 Oct 2017 17:48:52 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Integration-Extension-APIs/Qlik-sense-initial-load-all-data-seems-to-corrupt-selection/m-p/862230#M2939</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2017-10-11T17:48:52Z</dc:date>
    </item>
  </channel>
</rss>

