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 is used to avoid duplicate OrderID's in the count

   Tip

   Notice chr(10) will give a line break and a calculation will appear after # Orders label. You have to format the number in the textbox using the Num function.

   

4. On the General tab, under...