Qlik sense doesn't load all rows

[markp201]

I have a simple one table query.  When I include all 7 fields, I get about 60,000 rows.

When I remove one string field from the list, I get all 6,000,000+ rows.

There are 113 distinct values for this one field.

When I query with other tools, I get all 6,000,000+ rows regardless of the fields selected.

Tried moving the field to various positions in the list but still get 60,000 rows.

Anyone else experience a similar issue ?

[Anil_Babu_Samineni]

I suggest you to use RowNo() as ID to get All rows. Because, Qlik always removes duplicate while reloading the application.

[markp201 · Accepted solution]

There are a few options to resolve this issue.  FYI - we have Sept 2018 version

1. OLEDB
   
   1. https://help.qlik.com/en-US/connectors/Subsystems/ODBC_connector_help/Content/Connectors_ODBC/Oracle...
      1. Desktop
         1. Folder referenced in link is wrong
         2. Folder which we found works
            1. %USERPROFILE%\AppData\Local\Programs\Qlik\Sense\Connectors\QvOdbcConnectorPackage\oracle\lib\network\admin
         3. Copy TNS files from the standard folder
            1. C:\app\<user>\product\11.2.0\client_1\Network\Admin
         4. Restart desktop
      2. Server
         1. Folder is correct
         2. Copy TNS files from the standard folder
            1. C:\app\<user>\product\11.2.0\client_1\Network\Admin
         3. May require restart/reboot (we're currently testing - can someone confirm?)
2. ODBC parameter
   1. MEMLIM = 200000
   2. We experienced some slow response on the desktop but server was good, maybe a bit faster

Hope this helps

[markp201]

I know duplicates will not appear for a straight table but on the load ?

Qlik removes duplicates while reloading even if I don't specify DISTINCT ?