QlikSense is not loading complete data from the database

[santhoo_san]

Hi,

I am trying to load 100mn row data from Postgrest SQL into QlikSense. It was loading properly, but suddenly it is loading only some lakh rows. I have not made any changes to the script. I also tried loading for a specific date by applying "where date=specific date", it showed right numbers. when I remove the date filter again it is loading only few rows.  Can some one help, why is this happening?

[Anonymous]

Have you tried to load few columns to test whether it works?

I am guessing maybe QV can not load some specific character in some columns.

Zhihong