Creating write tables

Do the following:

1. In the assets panel, open Charts.

2. Under Visualizations, drag a Write table to the sheet.

3. Click Add dimension and select a dimension or a field.

4. Add additional dimension and measure columns by clicking under Data in the properties panel. A dropdown opens. Select either of the following:

   • Fields & master items: Opens a searchable dialog box displaying every field and master item. You can choose to add any item as a dimension or measure.
   • Custom expression: Opens a dialog box where you can type in an expression, or open the expression editor .

5. Add editable columns by clicking under Data in the properties panel, and selecting one of the following:

   • Create new editable column: Create a new, blank editable column.

   • Add existing editable columns: Use existing editable columns that match the primary keys defined for your write table.

6. By default, a new change store is created for newly created write tables. Optionally, under Change store in the properties panel, select an existing change store from the current space.

7. Define one or more primary keys for the table. In the write table, within the editable column, click Define, and select one or more dimension columns to use as the primary keys.

8. Click Save.

After you create the write table, allow users to interact with it and add changes to editable columns. You can also customize the appearance of the write table by configuring its properties and incorporating it into custom themes. See:

• Configuring write tables

• Qlik Developer Portal: Write table theme properties