Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to get all records in straight table without missing?


I have a straight table with data. The columns are

Name, DateEntered, DaysinQueue.

All the records are updating from access database. But there ate two records in access database with DateEntered as 28/04/2014 12:16:36 and another record with DateEntered as 28/04/2014 13:43:18. Only these two records are not updating in the file.

Could anyone suggest me how to get this records?


33 Replies

This records are timestamp formats if you not want time stamp try to change in the load script


Date(DateEntered,'DD/MM/YYY') AS DateEntered

From Location;

Not applicable

Thanks. I tried it earlier itself. But it is not working. Any solution please?


Otherwise make all timestamp like

Timestamp(DateEntered,'DD/MM/YYYY hh:mm:ss') AS DateEntered

Not applicable

Thanks. Actually I don't have any problem with timestamp or without timestamp. Because other records are populating. Only the above two are missing. How can I set this?

Not applicable

try adding rowno()

This creates a unique row for each data entry.

else try removing last part of the load statement from memory msq? this will force it to load all data and not ignore a line with same data as another line.

Specialist III
Specialist III

Do you have any data exclusion logic in your where clause and as a result these two records are getting ignored?


May be due to some logic this date is not display for cross check that your model is fetch this record or not try to write a where condition in another separate application by taking backup of previous one.

write like






From Location

Where DateEntered = '28/04/2014 12:16:36' and DateEntered = '28/04/2014 13:43:18';

Try to populate only based on this two records and do this where this fro DateEntered field where is is available in the tables.

Not applicable

no don't have any where clause.

Contributor III
Contributor III

Load rowno() as anyfield in load statement and in straight table add anyfield and hide it