I have a Qlikview file where data is load from a database and excel file. Now the database connection is revoked and i missed the excel source. I want to load a new excel to the existing data source without disturbing the existing data or charts. Can some one help me here how to load the new source file into qlikview?
Does the new source has the same column names as the revoked excel source?? If they are you can replace the old one with the new one and nothing in your application should break. I recommend making a copy of your application and then trying with the new source, so that in case something break you will have a back copy to go to.
If you do a reload from this new source file, you will lose the data that was loaded from the database (unless you saved that in a QVD - or other file form). I am assuming that you want to keep the data as you can no longer retrieve it from the database.
What I would suggest is that you create a copy of the qvw file. In the new copy, clear out the load script and start a new script with a binary load of the first document. Then, either:
save the relevant data to a QVD file, which you can then use as a data source in place of the database.
or, use that as the start of a longer script that adds the data from the new source through concatenation and/or joining) to the tables you binary loaded.
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein