Qlik Data to Excel / Add Data / Import Table
Qlik Data to Excel / Add Data / Import Table & Objects from your data model
This button will activate the Table Property Panel on right side, which allows you to import an existing Tables / Objects from your app Qlik Sense app directly into an
Excel table or create a new one. Use the Dropdown to Select an existing Objects from Qlik Sense you would like to import. See below:
5 options: import Data (Qlik Data to Excel), change Sorting , Add-Ons, Appearance, Settings
Now you can add existing objects from your app or directly from the data model. Once a Qlik Object to import is selected, all Columns within that table will be placed into the Data section of the Sense Excel Table Property Panel.
Add chart objects or table objects or add manuel from data model. e.g.:
- select Chart-Type: “Qlik Sense Pie-Chart objects”
- select Chart-Objects: “Sales Customer (Pie-Chart)”
- all dimensions and measures will be imported promt
Now can see the imported data elements for further processing. (sorting, editing…)
This feature allows Sense Excel access to Custom Formulas a Qlik Sense App Developer may have only used to define Columns within a Qlik Object but have not added as data model Fields or defined as Master Items.