Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
manu1512
Creator
Creator

Missing records

Hi all,

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

Ps:This question was asked in interview

3 Replies
jwjackso
Specialist III
Specialist III

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.DuplicateData.PNG

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
Creator
Creator
Author

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?