Conditional input control

By default, all users with the appropriate permissions can input data in the Qommentary Writeback tables. However, you can also disable data input for an entire input column or for individual cells with the use of Qlik Sense expressions.

There are 2 types of expressions you can apply:

Level	Description	Example
Column	All cells will be enabled or disabled	=1 (enable) or =0 (disable)
Row	Only cells which pass the condition will be enabled	=if('col.Status' = 'Open', 1, 0)

Working with row-level expressions provides greater flexibility and control to apply complex conditional calculations referencing more than one input column at a time.

Examples:

=if('col.Priority' >= 3, 1, 0) Enable input only if value in Priority column (type=Rating) is greater or equal than 3.

=if('col.Target' > 60 && 'col.Approved' <> 'true', 1, 0) Enable input only if value in Target column (type=Number) is greater than 60 AND Approved column (type=checkbox) is not true.

=if('col.Status' = 'Approved' OR 'col.Status' = 'Closed' 60 && 'col.Rank' < 40, 1, 0) Enable input only if value in Status column (type=Dropdown) is Approved or Closed AND Rank column (type=Number) is less than 40.

The keyword col allows you to access values from other input columns found on the same row at runtime.

To enable or disable data input, please follow these steps:

1. Edit your sheet and select the Qommentary Writeback extension 2. Expand the Input Columns section and input control you wish to alter 3. Scroll down to the Allow editing if property

4. Enter an expression which would return a number 1 (enabled) or 0 (disabled)

The conditional edit expressions have been applied successfully