Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
sharlo123
New Contributor II

Qlik Sense: How to duplicate an App and replace the data sheet

I have created an App with charts linked to an Excel spreadsheet and want to duplicate it and replace the data. I am unable to do this as when I add the new data and remove the old one the charts no longer connect to the data sheet even though all the fields match. Am I missing something? This should be easy.

1 Solution

Accepted Solutions
sharlo123
New Contributor II

Re: Qlik Sense: How to duplicate an App and replace the data sheet

Thank you both for your help.

I duplicated the App by creating a new App and dragging a copy of my original .qvf file (saved in Windows 10, This PC> Documents>Qlik>Sense>Apps)into it.

1) I loaded my new data as described by Lakshmikandh by pointing to the new spreadsheet. (All field names had to match exactly or I got an Synth key error)

2) I loaded it and checked that the file was working.

3) I deleted the original spreadsheet and the new one seems to work with my previously created charts

Thanks everyone.

If anyone else has an easier way to do this please let me know.

10 Replies
okolyug16
Contributor II

Re: Qlik Sense: How to duplicate an App and replace the data sheet

When you say 'replace the data', are you updating the data in the same spreadsheet used in the original app or is the data in a different spreadsheet? If the original spreadsheet was updated you'll need to refresh the data.

Attaching data files and adding the data to the app ‒ Qlik Sense

sharlo123
New Contributor II

Re: Qlik Sense: How to duplicate an App and replace the data sheet

I want to totally replace the Excel file.

sharlo123
New Contributor II

Re: Qlik Sense: How to duplicate an App and replace the data sheet

I also now see from your link that Attach file isn't available in the Desktop version which is what I am using.

lakshmikandh
Valued Contributor II

Re: Qlik Sense: How to duplicate an App and replace the data sheet

Hi,

In same app your scenario will not work with same columns, duplicate the app and then change the data load editor to point the new data sheet and load the new data to it.

In case you want this to be done on the same app with two sheets you add a column called as "Flag" and fill it as "Dataset1" and the new data as "Dataset2" and add one more filter to your app on top with this field "Flag".

Thanks,

Lakshmikandh

sharlo123
New Contributor II

Re: Qlik Sense: How to duplicate an App and replace the data sheet

Does this mean that it can't be done?

lakshmikandh
Valued Contributor II

Re: Qlik Sense: How to duplicate an App and replace the data sheet

you can replace the existing excel totally by making it to point different place in data load editor.

in Left top there will be menu option to go to data load editor and change the file location.

okolyug16
Contributor II

Re: Qlik Sense: How to duplicate an App and replace the data sheet

I think files can be used as a data source in the desktop version as well, assuming your spreadsheet is stored on your desktop as newfile.xls, try these steps

In the new app create a new data connection to your desktop: Navigation Menu--> Data Load Editor Create New connection --> folder --> enter the path to your desktop(like C:\Users\xxx\Desktop) --> Name the connection(something like Folder). After these steps you should have a connection to the desktop(location of your file), it'll look like the image below;

Capture.PNG

Next in the load script update the FROM syntax to point to your file, so you'll end up with something like

LOAD *

FROM [lib://Folders/newfile.xls]

Then Load the Data

sharlo123
New Contributor II

Re: Qlik Sense: How to duplicate an App and replace the data sheet

Thank you both for your help.

I duplicated the App by creating a new App and dragging a copy of my original .qvf file (saved in Windows 10, This PC> Documents>Qlik>Sense>Apps)into it.

1) I loaded my new data as described by Lakshmikandh by pointing to the new spreadsheet. (All field names had to match exactly or I got an Synth key error)

2) I loaded it and checked that the file was working.

3) I deleted the original spreadsheet and the new one seems to work with my previously created charts

Thanks everyone.

If anyone else has an easier way to do this please let me know.

brianna_in_dc
New Contributor III

Re: Qlik Sense: How to duplicate an App and replace the data sheet

Hi,

Is there a way to replace the Excel file if I added one column in the new Excel file? One of you mention that the column headings must match.

Community Browser