Qlik Community

Qlik Sense Data Connectivity

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Not applicable

Access DataBase import results limits

Hi,

I succeded to link my Qlik application with an Acces Dabatase (.accde) through the OLE DB connexion.

The issue is that Qlik only import the 100 (among 10 000) rows of the database. It seems that Qlik does not find the remaining results...

When I open the database with Acces, only the 100 first results appears unless I chose "display all" filter.

I assume that my issue come from this default setting of 100 results displayed but I still don't know how to avoid it.

Would you have an idea ?

Thanks a lot for your help,

Alexis

Tags (1)
1 Solution

Accepted Solutions
oknotsen
Honored Contributor III

Re: Access DataBase import results limits

Are you sure Qlik only loads 100 rows?

Reason I am asking is that it is a common misunderstanding that the preview in the Data Model Viewer shows all data. It does not; it only shows X records (100 sounds about right; I never counted).

May you live in interesting times!
4 Replies
oknotsen
Honored Contributor III

Re: Access DataBase import results limits

Are you sure Qlik only loads 100 rows?

Reason I am asking is that it is a common misunderstanding that the preview in the Data Model Viewer shows all data. It does not; it only shows X records (100 sounds about right; I never counted).

May you live in interesting times!
Not applicable

Re: Access DataBase import results limits

You did a strike.

Thank you !

oknotsen
Honored Contributor III

Re: Access DataBase import results limits

If your question is now answered, please flag the Correct Answer (via the big "Correct Answer" button near every post).

If not, please make clear what part of this topic you still need help with .

May you live in interesting times!
Not applicable

Re: Access DataBase import results limits

Hi Onno,

Finally, I still have an issue with the number of rows imported from the access database. You maybe know how to help.

I've noticed that if I open the Access database and apply filters that reduce the total result to 200 rows (for instance), Qlik only load the 200 rows that are filtered. I tried without filters, qlik loads all the rows (80K+).

How can tell to Qlik "Load all the rows, whatever the filters status"? I assume that it is possible using the script but I could not find how.

Hope it's clear. Thanks a lot.

Alexis

Community Browser