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.
rol_sepulveda
Not applicable

Replace data qlik sense

Good day,

I have a problem trying to update my data in Qlik sense 2. In previous version there was a option "Replace data", and now does not longer exist. Now only exist the option "Add data", so if I already have data in my report, it will be duplicate my info.

Please help.

Best regards.

12 Replies
abhaysingh
Not applicable

Re: Replace data qlik sense

Hi Rolando,

Could you pls tell me where u want to replace data at front end or backend??

Regards

Abhay

sunilkumarqv
Not applicable

Re: Replace data qlik sense

Copy the same script of yours then replace with your new Qlik sense version

rol_sepulveda
Not applicable

Re: Replace data qlik sense

In version 1 you had the possibility to choose if you wanted add or replace data.

version1.PNG

In version 2 you don´t have the option. You have to specify directly a data source.

version2.PNG

Thanks for your help.

Not applicable

Re: Replace data qlik sense

yes, I also have just installed Qlik Sense Desktop v2, and want to revise the data set I've previously used. Actually the question is not so much about upgrading to the new version, but asking how to do a replace data within version 2. My Qlik Sense app uses two different data sources/files, and I have been expanding the elements available in one of them (.csv or .xlsx). Is there a 'replace' function in v 2 that is analogous to the Quick Data Load option of v 1.1?

petter
Not applicable

Re: Replace data qlik sense

ADD DATA is in the DATA MANAGER. ADD DATA means adding some extra tables from another source ... you should use the DATA LOAD EDITOR and the LOAD DATA button there ...

rol_sepulveda
Not applicable

Re: Replace data qlik sense

When I add data the report duplicates the results

petter
Not applicable

Re: Replace data qlik sense

You shouldn't use "add data" you should use "load data" the you will reload with fresh data without adding ...

Not applicable

Re: Replace data qlik sense

Peter, thanks for this quick reply. And nope, I had not seen that "Load Data" button in Data Load Editor window. That said, when I use the Load Data option, I believe I am refreshing the values in the previously structured data set. This is a good thing for when I'm working with a revised set of data; e.g., trends over month data. But I want to be able to add new data elements --along with the values for each record in the data set-- to my QlikSense app. Under v 1.1, I could use the "Replace Data" option (from the quick load menu), and then all prior data --values and elements-- would be replaced with the new file. Yes, I had to load my peripheral files that did not change, but at least I could grab the new fields. I don't know how to do this sort of expansion; i.e., either the same named file with new elements/columns, or a differently named file with different elements/columns. Is this capability included in v 2.0?

rnt
Not applicable

Re: Replace data qlik sense

When you Add data in Data manager the information is persisted in a separate load model behind the scene, which results in auto-generated script code that you can't edit unless you unlock it.

If you take a pre-2.0 app where you used Quick data load, the information is persisted in the actual data load script code.

That means, in the Data manager, you can change selections and remove data tables you added with Add data, but only view tables that are result of "written" script code from Data load editor.

I would recommend you go to the Data load editor, and delete the script code that's loading the data files, and then use Add data to add them back. After this, you can handle your data sources in Data manager. Replacing files is just a matter of deleting them, and then adding the new file.

This is only true for straight-forward table loads, beyond that you will need to use the data load editor.