Skip to Main Content
Hands-On Business Intelligence with Qlik Sense
book

Hands-On Business Intelligence with Qlik Sense

by Pablo Labbe, Clever Anjos, Kaushik Solanki, Jerry DiMaso
February 2019
Beginner to intermediate content levelBeginner to intermediate
442 pages
9h 38m
English
Packt Publishing
Content preview from 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:
  1. Click on Add dimension and select OrderID in the Dimensions ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

AI-Powered Business Intelligence

AI-Powered Business Intelligence

Tobias Zwingmann
Data Management at Scale

Data Management at Scale

Piethein Strengholt

Publisher Resources

ISBN: 9781789800944Supplemental Content