Hands-On Business Intelligence with Qlik Sense

Condition to filter data on a measure

Here, we will learn how to create a measure in a table visualization using a condition to show only the sales amount for orders shipped the next day of the order date.

We will add the visualization, Table chart with dimensions OrderID, ShippedDate, OrderDate, and measure with Sales Amount with the shipped date condition.

Follow these steps to create the visualizations:

1. Click on the Edit button to enter the edit mode.
2. Click on the Charts button on the asset panel, which is on the left-hand side of the screen, and find the Table chart.
3. Click on the Table chart, and then drag and drop it into the empty space on the right-hand side of the sheet:

4. Click on Add dimension and select OrderID in the Dimensions ...