Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
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

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 ?