Solved: Re: Qlik Sense: How to duplicate an App and replac... - Qlik Community

Anonymous · ‎2016-09-22

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.

Anonymous · ‎2016-09-22

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.

View solution in original post

Anonymous · ‎2016-09-22

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

Anonymous · ‎2016-09-22

I want to totally replace the Excel file.

Anonymous · ‎2016-09-22

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

lakshmikandh · ‎2016-09-22

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

Anonymous · ‎2016-09-22

Does this mean that it can't be done?

lakshmikandh · ‎2016-09-22

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.

Anonymous · ‎2016-09-22

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;

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

Anonymous · ‎2016-09-22