# Configuring editable columns

An editable column is a special type of column that is only available in a write table.

## What is an editable column?

In a write table, editable columns allow users to enter data on the fly during analysis. By saving changes to an editable column, a user writes changes to a [change store](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Visualizations/WriteTable/Create/change-store.htm), from which they can be retrieved by application developers and integrators.

## Adding an editable column

Do the following:

1. Create a new write table and add dimension and measure columns.

   [Creating write tables](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Visualizations/WriteTable/Create/create.htm)

2. In the properties panel, expand Data.

3. Click the Add editable columns icon, and then select 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](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Visualizations/WriteTable/Create/primary-key.htm) defined for your write table.

After adding the editable column, you can configure its appearance and how users can interact with it. See [Configuring editable columns](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Visualizations/WriteTable/Create/editable-column.htm#ConfigureEditable).

## Configuring editable columns

Do the following:

1. In the properties panel, under Data, click the editable column.

   The column properties open.

2. You can change any of the following properties:

   * Title: Change the default column title.

   * Show content: Change how users can edit data in the table. You can choose between:

     * Manual user input: Users edit data by typing text manually into cells.

       [Manual entry](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Visualizations/WriteTable/Analyze/write-table.htm#Manual)

     * Single selection: Specify a set of values that users can select for each cell when editing. For example, you could add two values for orders statuses: On Track and Late. Users can then select between these values when they comment on data records.

       For single selection, you can use either fixed or dynamic values:

       * Fixed: Define values manually by typing them into the entry box. These values are static and do not change with application data.

       * Dynamic: Use expressions to define input values that can change depending on the value of an expression. For example, you can link values to a data model field, or to application variables. You can specify values and labels, or just values.

         For more information about using expressions in visualizations, see [Using expressions in visualizations](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/use-expressions-in-visualizations.htm).

         Tip note

         Syntax:

         Use | to separate values and ~ to separate value and label, like this: value1|value2 or value1~label1|value2~label2.

         Information note

         Up to 1000 values are supported. Values exceeding the limit will be ignored.

         [](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Visualizations/WriteTable/Create/editable-column.htm)

         #### Examples

         ```
         =Concat(Country, '|')
         ```

         ```
         =Concat(DISTINCT City & '~' & Upper(City), '|')
         ```

         ```
         ='Product A|Product B|Product C'
         ```

         ```
         ='$(vMyVariable)'
         ```

         ```
         ='ProductA-value~ProductA-label|ProductB-value~ProductB-label'
         ```

       [Single selection](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Visualizations/WriteTable/Analyze/write-table.htm#SingleSelect)

     * Date picker: Users select a date for each cell when editing.

       Information noteIn the user interface, dates entered by users are displayed in the date format defined by the application load script (see [DateFormat](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Scripting/NumberInterpretationVariables/DateFormat.htm)). These dates are stored in the change store in ISO 8601 format.

       [Date picker](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Visualizations/WriteTable/Analyze/write-table.htm#DatePicker)

   * Show column: Toggle whether the column is visible or hidden.

   * Column width: Set the width of the column.

## Styling editable columns

For information about styling the appearance of editable columns, see [Styling editable columns](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Visualizations/WriteTable/Create/style.htm#StyleEditable).

## Learn more

* [Creating write tables](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Visualizations/WriteTable/Create/create.htm)

* [Write table](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Visualizations/WriteTable/Analyze/write-table.htm)

* [Working with change stores](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Visualizations/WriteTable/Create/change-store.htm)

* [Primary keys in write tables](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Visualizations/WriteTable/Create/primary-key.htm)

* [How to extract changes from the Change Store (Write Table) and store them in a database using Qlik Automate](https://community.qlik.com/t5/Official-Support-Articles/How-to-extract-changes-from-the-Change-Store-Write-Table-and/ta-p/2537848)