Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Adding Excel Data without Losing Previous Data Load

Hi!

I've been working on designing my first Qlikview dashboard with data that was loaded into the document by the IT department at the company I work for. I don't have access to the database from which they loaded the data I'm working with.

I'd like to add a table to the existing data which joins on "Fiscal_Period" in order to add the field "Working_Day" which will allow me to know the number of work days for a given fiscal period.

Is there a way to add this table without clicking "reload" and losing all of the data I do not have access to?

Thanks an advance for any help!

1 Solution

Accepted Solutions
atkinsow
Valued Contributor II

Re: Adding Excel Data without Losing Previous Data Load

You could either change script to do a Partial Reload.

What is meant by partial reload? What is its use? Please explain!

OR

You could create a blank application that pulls in the original data in the original QVW through a binary load.

Binary Load | Qlik Community

3 Replies
atkinsow
Valued Contributor II

Re: Adding Excel Data without Losing Previous Data Load

You could either change script to do a Partial Reload.

What is meant by partial reload? What is its use? Please explain!

OR

You could create a blank application that pulls in the original data in the original QVW through a binary load.

Binary Load | Qlik Community

Not applicable

Re: Adding Excel Data without Losing Previous Data Load

Thanks for your help!

Couldn't get the binary solution to work, but was able to figure out the partial reload.

atkinsow
Valued Contributor II

Re: Adding Excel Data without Losing Previous Data Load

Glad you figured out something!

Please close the thread if you are all good now.

Qlik Community Tip: Marking Replies as Correct or Helpful

Community Browser