QlikView Essentials

Creating a text object

Text objects are a good way of displaying labels and expressions. Text objects can be made interactive by specifying Actions in the properties. Since we are working on a Dashboard sheet, we will create text objects to display summarized information. We will create text objects for number of Orders, number of Customers, and Total Sales:

1. Use QlikViewEssentials_Presentation.qvw.
2. Right-click on the empty space on the Dashboard sheet. Select New Sheet Object and then the text object.
3. On the General tab, in the Text edit box, type the following expression for # of Orders. Remember to put = in front of the expression. If you are displaying labels then you don't need =:

   ='# Orders ' & chr(10) & Num(count(distinct OrderID),'#,##0') Distinct ...