Setting field values as null in a table

In the Set nulls card, you select distinct values from a dimension field to be treated as null values in Qlik Sense. For example, if your source data includes representations such as X for nulls, you can use the Set nulls card to set that value to be treated as a null value in Qlik Sense. You can also use the Set nulls card to clean your data of unwanted values by setting these values as null.

You can set field values as null in fields that meet the following requirements:

• Fields must be set as dimensions in the Summary card.
• Fields must contain up to a maximum of 100 distinct values.
• Fields are not dimension fields created using the Bucket card or the Split card.
• Fields are not calculated fields.
• Fields are not in a concatenated table.

• Fields are not in an unpivoted table.

  Information note

  Field values can be set as null before a table is unpivoted. Once a table is unpivoted, manually setting values as null is not available until the unpivoting is undone.

The Set nulls card has the following limitations:

• You cannot set replacement values from the Replace card as null.
• You cannot set null values and then change the order of values with the Order card. You must restore all manual null values in a field before you can use the Order card with that field.

The Set nulls card consists of two sections, Distinct values and Manual null values. When you select values from Distinct values, they are added to Manual null values. When you apply the null values, all instances of the selected values are set to null in the field's data. You can restore individual or all values set as null.

Setting field values as null

Do the following:

1. In Data manager, select a table and click @.
2. Select a field.
3. In the data profiling card, click the Set nulls card.
4. Under Distinct values, select the values you want set as null.
5. Click Set null values.

Restoring values manually set as null

Do the following:

1. In Data manager, select a table and click @.
2. Select a field.
3. In the data profiling card, click the Set nulls card.

4. In the Set nulls card, under Manual null values, do one of the following:

   • Click E after the values you no longer want set as null.
   • Click Remove All to restore all values set as null.
5. Click Set null values.