Missing records

[manu1512]

Hi all,

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

Ps:This question was asked in interview

[jwjackso]

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.

[manu1512]

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

[Digvijay_Singh]

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?