Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
abonnery
Contributor III
Contributor III

Export data model and data associations

Hello, 

 

I am looking for a way to store/export an entire data model (made of several tables and data associations/keys) into a single file (whatever the format as long as I can export it to a dedicated folder). 

I know of qvd but, the exported data is flat for this format, meaning the relation between the table is lost during the export. 

The purpose of the export would be to reload the data model into another app without having to recreate numerous tables and data associations in this new app. 

Do you know of a specific format/feature of qlik sense that would allow this ? How could I implement it ?

 

Thank you very much for your help.

 

 

Labels (1)
4 Replies
Patricia_Silva
Specialist II
Specialist II

Hello @abonnery I am not aware of any feature like this in Qlik Sense, I have just found the following for QlikView but I would say it would be the same in Qlik Sense side, but in cany case it is maybe not exactly what you expect, yes? https://audministrator.wordpress.com/2019/02/22/qlikview-how-to-export-the-full-data-model-to-excel/ 

On the other hand, I have also checked in our Ideation program and I could not see any idea submitted regarding this feature, so I would kindly suggest you to submit it there so our R&D team might assess this feature for future releases 😊 

You can use the following link to submit any idea: https://community.qlik.com/t5/Suggest-an-Idea/idb-p/qlik-ideas

Thank you!

Help users find answers! Don't forget to mark a correct resolution 🙂
marcus_sommer

It sounds that you are looking for a binary load:

Binary ‒ Qlik Sense on Windows

 - Marcus

abonnery
Contributor III
Contributor III
Author

Hello, 

I have heard the binary statement doesn't work for enterprises, instead we choose export a qvf and load it from the app where we want to exploit the data. Is this the way of doing ?

 

eddie_wagt
Partner - Creator III
Partner - Creator III

Hello @abonnery ,

There are some limitations, but also workarounds

Limitations:  

You cannot use binary to load data from an app in a managed space. The app must be in a personal space or a shared space.

You cannot upload QVW or QVF files to the /DataFiles folder. Instead, you can upload the file to a file share, for example AWS S3 or Google Drive, and then load the data from a data connection connected to the file share.

https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptRegularS...

Regards Eddie