Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

markp201
Contributor III

Qlik sense doesn't load all rows

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 ?

1 Solution

Accepted Solutions
markp201
Contributor III

Re: Qlik sense doesn't load all rows

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

View solution in original post

3 Replies

Re: Qlik sense doesn't load all rows

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
markp201
Contributor III

Re: Qlik sense doesn't load all rows

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

View solution in original post

Highlighted
markp201
Contributor III

Re: Qlik sense doesn't load all rows

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 ?