Vizlib Home Try Vizlib

Vizlib Writeback Table Guides - Analysis Mode

When you've finished editing in Vizlib 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 the Sort function to re-arrange column values in order. 

Sorting is very simple, just click on the column header and the values will be ordered with the largest or highest value first. 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

Back to Contents

Filtering Column Values

Vizlib 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

Back to Contents

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

Note: During the export, the underlying data (hypercube) is exported (similar to native Qlik Sense exports), and not the writeback table itself. 

Back to Contents 

Copying Cell Values

If you right-click on a non-editable cell in a writeback table, the context menu now has an option Copy Cell Value. When you copy the cell value, move to an empty cell and right-click, you can paste the cell value into the empty cell (Figure 4).

Figure 4: Copy Cell Value

Back to Contents

Kenneth is the author of this solution article.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.