Conditional input control

By default, all users with the appropriate permissions can input data in the Qommentary Form. However, you can also disable data input with the use of Qlik Sense expressions.

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

1. Edit your sheet and select the Qommentary Form extension 2. Expand the Input fields 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)

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

Examples:

=if('col.TargetRevenue' >= 1500, 1, 0) Enable input in Performance field (type=Rating) only if TargetReveune value is greater or equal than 1500.

=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' && '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 fields found on the same form at runtime.

The conditional edit expressions have been applied successfully

If TargetReveune field value is greater or equal than 1500 then Performance field will be enabled