Discussion Board for collaboration related to QlikView App Development.
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?
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?
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.
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.
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.