topic Re: Missing records in QlikView

Missing records

manu1512 — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

Can anyone tell me what can be the reason fir missing records in qlikview?

Ps:This question was asked in interview

Re: Missing records

jwjackso — Fri, 30 Mar 2018 11:33:13 GMT

Is the data really missing. By default Qlik displays unique rows. I created 2 tables where the rows are identical. Look how the data is displayed.

DataSet1:
LOAD * Inline [
Dept,Value
D101,100
D101,100
];

DataSet2:
LOAD *,
RowNo() as RowID;
LOAD * Inline [
Dept1,Value1
D101,100
D101,100
];

If the data is really missing, that is a whole different story and then you need to review the load scripts.

Re: Missing records

manu1512 — Fri, 30 Mar 2018 11:36:17 GMT

theoretical can you please tell me what may be reason for missing data if we load from large data source?

Re: Missing records

Digvijay_Singh — Fri, 30 Mar 2018 12:57:03 GMT

I don't think this is a complete question. Its giving impression like Qlik sometimes doesn't load all the data . There was a limit of 2 billion unique values in symbol table but not sure if it still exists -

Re: Can QlikView Handle more than 2 billion unique records in it is objects?