Boolean Input in Qlik: Using Checkboxes with Dataplus

Working with input fields in Qlik Sense is essential for planning and controlling apps. With the Data+ Suite by Leitart, it becomes not only possible – but intuitive. In this article, we show how to use checkboxes as a Boolean input in a Data+ Table – using a discount flag for sales positions as an example.

Goal:

In our sales app, we want to control whether a sales item is eligible for a discount. A true/false field is all we need – and checkboxes is the perfect match.

Step 1: Add the column in the admin panel

We start by creating a new column in the Data+ Table admin area, e.g., called Discount. Note: Even for Boolean input, the format remains string. You'll convert the value later in the load script if needed.

Step 2: Configure the checkboxes in the table

Back in the worksheet, we reconnect the table (required after admin changes) and add the new column in the Data+ properties:

• Type: Checkboxes

• Label: Discount

• Target Column: Discount

Once saved via the floppy disk icon, the checkbox is ready to use.

Good to know:

By default, a checkbox only stores data if it’s actively ticked. Empty rows are not considered "false". To set explicit false values, make sure to uncheck and save as well.

Handle the data in the load script

Next, we include the column in the Data+ load script. You’ll notice: the values are stored as strings. A simple IF() condition in the load statement can transform this into a real Boolean field.

Conclusion

Checkboxes are a great way to capture simple decisions in Qlik Sense – like discount eligibility, activity flags or yes/no questions. With Data+, you can easily integrate them into your applications – with full database support.