Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. Register by February 29th to save $200. Learn More
cheongweei
New Contributor III

Unable to change Data Connection

I am using QlikSense on a desktop.  I would like to move my data file to another directory and would like to change the data connection path.  However, both the edit and delete icon is greyed out.  Anyone know why I can't edit the connection?

Tags (1)
1 Solution

Accepted Solutions
Highlighted
Luminary
Luminary

Re: Unable to change Data Connection

You can't have the cake and eat it. If you want to edit the connection, you have to unlock the script. Then you can go back to the data manager and synchronize the tables, so they will be locked again in the script and available in the data manager view.

https://help.qlik.com/en-US/sense/September2018/Subsystems/Hub/Content/Sense_Hub/LoadData/synchroniz...

However, I would recommend that you spend some time on working with the data load editor, it provides much more flexibility.

View solution in original post

6 Replies
Highlighted
Luminary
Luminary

Re: Unable to change Data Connection

Is your script section locked?

Highlighted

Re: Unable to change Data Connection

Are you really sure - Are you using Desktop?

If Yes, Can you close and reopen the software to debug.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
Partner
Partner

Re: Unable to change Data Connection

Hi,

Seems strange for desktop as the only reason i can think for them to be greyed out is permissions.

Can you not just add a new library and repoint the script.

Mark

Highlighted
Luminary
Luminary

Re: Unable to change Data Connection

Confirmed, if your section is locked you cannot edit the connection. Press the unlock button.

Capture.PNG

Highlighted
cheongweei
New Contributor III

Re: Unable to change Data Connection

Yes the auto-generated script is locked.  I only want to change the data location and not the script.

I do not want to unlock the Auto-generated script as I want that to remain auto-generated. The script cannot be locked back once it is unlocked even if I only change the data connection

Highlighted
Luminary
Luminary

Re: Unable to change Data Connection

You can't have the cake and eat it. If you want to edit the connection, you have to unlock the script. Then you can go back to the data manager and synchronize the tables, so they will be locked again in the script and available in the data manager view.

https://help.qlik.com/en-US/sense/September2018/Subsystems/Hub/Content/Sense_Hub/LoadData/synchroniz...

However, I would recommend that you spend some time on working with the data load editor, it provides much more flexibility.

View solution in original post