Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Specialist II
Specialist II

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.

Highlighted
Creator
Creator

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

Highlighted
Master III
Master III

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?