Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
Not applicable

Issue while fetching mongodb data to Qlikview

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.

Tags (3)
2 Replies
balabhaskarqlik
Honored Contributor

Re: Issue while fetching mongodb data to Qlikview

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.

Not applicable

Re: Issue while fetching mongodb data to Qlikview

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