Vizlib Writeback Table can help you drive improvements in your data quality by offering validation conditions.
With validation, data entered into a column field is checked against any conditions you've specified. If these conditions aren't met, an error will be returned and displayed, and the user will not be able to insert invalidated data. Setting validation rules can mean selecting a particular type of data, such as numeric values only, or collecting data in a recognised format, such as an email address.
Validation ensures the information you collect and hold in your system follows your schema, defined format and appropriate for your requirements, which can open the door to a wide range of benefits for an organisation. As an example, accurate sales data can be used to produce more specialised and focused sales reporting, and can drive improved targets in customer retention and acquisition.
Start using the Validation panel by selecting the column you want to work with (Figure 1).
- Move the Required slider to the right to show Yes to display the validation commands.
Figure 1: Validation Controls
- If no text is entered in a data field, then by default an error message will be highlighted. This will disappear when you enter some data which meets your validation conditions. As the default validation setting is No Validation, the error will disappear if any text is entered.
- Select one of the validation types from the dropdown (this article will use Alphanmeric).
- Alphanumeric - value must contain letters and numbers.
- No Validation - value not restricted by any conditions.
- Email - value must be a valid email address.
- Phone - value must be a valid phone number.
- Alpha - value must contain letters only.
- Regex - value must contain a specified regular expression (e.g. password format).
- Expression - value must match a specified Qlik Sense expression.
- If you enter text that complies with the validation condition, the error will disappear (Figure 2).
Figure 2: Validation Success
- If you enter a special character into the data field, the error message will return (Figure 3).
Figure 3: Validation Failure
If you want to specify an error message or add instructions, you can use the text fields provided. (Figure 4).
- Enter the message to display if validation fails the Error Message text box.
- Enter the display text for the label next to the column name (*) in the Required Label text box.
Figure 4: Error Message and Required Label
- You can also change the Validation Label Color by selecting a panel from the drop-down palette or entering the hex reference for the color in the expression text box. Figure 5 shows the label has been changed to black.
Figure 5: Validation Label Color
You can find a list of related articles in the Vizlib Writeback Table Overview.