When you've finished editing your Writeback table, there are several functions you can use in analysis mode to help display data exactly the way you need it.
Sorting Column Values
You can use Vizlib Writeback Table Sort function to re-arrange column values in order.
Sorting a Writeback Table is very simple, just click on the column header and the values will be ordered with the largest or highest value first. The example in Figure 1 shows how ordering works with a toggle and a Rating data type.
Note: Sort can only be used on data types defined in the Qlik Sense data model used by the writeback table, so you won't be able to sort on a Calculated Column, for example.
Figure 1: Writeback Table Sort
Filtering Column Values
Writeback Table also has a Filter function which you can use to select and highlight a set of values in a dimension field.
Click on the filter icon beside the column name, then enter your filter criteria, click to select the result and click to apply the filter to the table. The example in Figure 2 shows a filter being applied to a text column.
Note: Filter can only be used on dimension columns, so you won't be able to sort on any columns displaying a measure, such as Numeric.
Figure 2: Writeback Table Filter
Exporting Column Values
The Vizlib Writeback Table export function helps you share data by exporting it into a data file.
Right-click on the table, select Export, then click on Export data to open the export window. Click on the link to download the file. Figure 3 shows an example which downloads an Excel file.
Figure 3: Writeback Table Export