If you want to start working with Vizlib Writeback Table, click on the sheet you'd like to work from in Qlik Sense Hub. When the sheet opens, follow these steps to create a table (Figure 1).
- Click on Custom Objects in the far-left panel, to open the custom objects menu.
- Select VizLib Collaboration.
- Click and hold the cursor on Vizlib Writeback Table.
- Drag and drop the cursor into the sheet.
- Drag the corner of the table view (highlighted in orange) to change the table size.
- Once the table initialises, you will see buttons for Set up and Manual Configuration.
- Click Set up to open the setup dialog. You can find instructions on Set up in our article here.
- Click Manual Configuration to complete setup using Writeback Settings.
Figure 1: Create New Writeback Table (Set up)
Note: Once you've created a new writeback table, you can click Done to save it in the app.
Adding New Data with Manual Configuration
Vizlib Writeback Table also uses Manual Configuration to add new data to your writeback table. You can add fields in the property panel on the right hand side of the screen.
When you click on Add Column, you'll see a dropdown with 3 options.
Figure 2: Add Column Dropdown
- Dimension - Dimensions are used to organise data into groups, e.g. a list of product types, or countries. They are defined in the data model loaded by the application hosting the writeback table, and can be added using Setup or Manual Configuration. You can add select a dimension already linked to a column in the data model, or you can choose to link to one of the Fields in the lower half of the dropdown.
- Measure -Measures are used for calculating data, e.g. the total sales for a product type sold, or the number of units sold per country. Like dimensions they are also defined in the data model using Qlik Sense aggregations, and can be added using Setup or Manual Configuration. You can select a measure which has an aggregation defined for a particular field, or select a field and add your own aggregation.
- Column - Columns can be added to display new data which hasn't been held in the data model, e.g. a comments section for each row. You can add a column using Setup or Manual Configuration, and select from a list of data types or utility types.
Once you've added a column, you define column properties in Columns. You can find more detailed information by reading the articles in the Properties category, which you can find on the homepage here.
Note on Column Order: With the current version of Vizlib Writeback Table, you'll need to disable touch screen mode in Qlik Sense if you'd like to use drag and drop to re-order columns in the property panel.