topic Re: Missing data while extraction from Salesforce to Qlikview in QlikView

Missing data while extraction from Salesforce to Qlikview

gunjesh0310 — Mon, 26 Jan 2026 21:26:37 GMT

Hi ,

I am facing issue while pulling the data from Salesforce to Qlikview and Mode = Bulk, Batch size=500.

Almost Missing 3000 records during extraction.

when putting where condition with Sales # for e.g.101,102,103 than these data are coming which are missing in full extract.

Load *;

sql select * from table;

Regards

Gunjesh Joshi

vishsaggi — Tue, 28 Aug 2018 19:43:44 GMT

Can you use this and check the record count:

LOAD *, Recno() As RecCnt;

SQL Select * FROM table;

gunjesh0310 — Wed, 29 Aug 2018 02:21:29 GMT

Hi Vishwarath,

Thanks for reply.

But still the count are same and missing 3000(approx.) record.no change.

SF having 156459 records and I am getting in qlikview 153400 records.

Mode = Bulk is using.

Regards,

Gunjesh Joshi

gunjesh0310 — Wed, 29 Aug 2018 18:44:17 GMT

Hi Qlikview Team,

Anyone can please help us?

Regards,

Gunjesh Joshi

vishsaggi — Wed, 29 Aug 2018 18:59:42 GMT

How are you counting the rows in both the sources? Like i mean in qlikview and in salesforce how are you counting rows?