You can save the table to a csv using the STORE command like below
store QlikviewTableName into myfile.txt (txt);
If you are using Table box you may not get the exact records, because it removes the duplicate records.
To display all the rows in Table box use below script, and mandatorily use the RowNum column in your table.
RowNo() AS RowNum,
Hope this helps you.
I have changed the script so it can look if the case is late approved and if a revised date have been agreed then this is used as "new" due date"
if([Revised due date]='', if(date#([Due date], 'MMM DD, YYYY') < date#([QA Approval date], 'MMM DD, YYYY'), 1, 0), if(date#([Revised due date], 'MMM DD, YYYY') < date#([QA Approval date], 'MMM DD, YYYY'), 1, 0)) as LateApprovedNC,
Below is an example how it should count
Due date Revised due date QA Approved date Outcome
Jan 1, 2015 Jan 30, 2015 Jan 25, 2015 No not count
Jan 1, 2015 Jan 25, 2015 Do count
Jan 1, 2015 Jan 30, 2015 Feb 2, 2015 Do count