topic Re: Issue while fetching mongodb data to Qlikview in QlikView

Issue while fetching mongodb data to Qlikview

Mon, 26 Jan 2026 18:19:17 GMT

Hello everyone,

I am trying to fetch data from Mongodb toward Qlikview.

The issue I'm facing is that when I run the script where I select my Mongodb collection, the number of lines fetched is different from the mongodb collection.

I have a total of 30094 lines in my mongodb collection. However, Qlikview says that I fetched only 4096 lines (eventhough I do a 'SELECT *' to my collection in the script section).

Help would be very much appreciated.

Re: Issue while fetching mongodb data to Qlikview

BalaBhaskar_Qlik — Tue, 04 Jul 2017 09:51:46 GMT

After "Select *" did you applied any where conditions? Are you seeing (qvd optimized) on the Script execution window.

If not, you might be applying some filter.

Re: Issue while fetching mongodb data to Qlikview

Tue, 04 Jul 2017 10:05:55 GMT

I don't have any where conditions after my SQL statement.
The only thing the script window is returning is this :

"Connecting to MongoDB_ODBC

Connected

Bonbon_collection 4 096 Lines fetched"

Here is a small sample of my collection file : https://pastebin.com/Q8vq7dAU

I think it might has something to do with the JSON formating of my collection