Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
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?
Regards,
Nandha
In the copy, use a script like this:
Binary <path to your orginal file>;
Store Table1 into Table.qvd (qvd);
Store Table2 into Table.qvd (qvd);
...
to make the qvds.
And then in another copy, load the data you were getting from the database from these qvds.
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.
Best,
Sunny
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:
Hi Jonathan,
Can you please explain me with an example?
Regards,
Nandha
In the copy, use a script like this:
Binary <path to your orginal file>;
Store Table1 into Table.qvd (qvd);
Store Table2 into Table.qvd (qvd);
...
to make the qvds.
And then in another copy, load the data you were getting from the database from these qvds.
Hi Jonathan,
Its not working.
Regards,
Nandha
Hi, what jonathan mentioned should work.
You can take a binary load of your previous document in a new QVW and store the data base tables into QVD's.
You can then use these QVD's anywhere.
Sample Script
Binary [..\documents\ankit\qw\test\new qlikview document (2).qvw];
SET ThousandSep=',';
SET DecimalSep='.';
SET MoneyThousandSep=',';
SET MoneyDecimalSep='.';
SET MoneyFormat='$#,##0.00;($#,##0.00)';
SET TimeFormat='h:mm:ss TT';
SET DateFormat='M/D/YYYY';
SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';
SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';
SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';
Store tablename into tablename.qvd(qvd);
Ok Ankit Thanks for your reply.
But how will i use my old visualization if i developed this in new qvw???
Regards,
Nandha
I think it will be a bit tedious work. You might have to recreate the dashboard again. You will have to copy paste the objects.
I am getting the below error. Pls help me here
Regards,
Nandha