You try opening QVD directly into a QVW( qlikiview application) so that you will be able to check whether data is there or not. Once you are sure that all the data is there in that qvw apps(after reload).
Again you try opening qvd in your application using Data from file option -> select table files and then desired QVD.
Then put some table name ex :-
From ------ (qvd). -> Save and reload. lets do this exercise and let us know are you still not able to see the table.
May be you will have to check script throughly else where have you mentioned drop table statement by mistake?