O'Reilly logo

QlikView Essentials by Chandraish Sinha

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required