Count Rows In a Table In QlikView

Introduction

This article explains how to count rows in a table. There are two functions used for counting rows in a table.

  • NoOfRows(Total)
  • RowNo(Total)

Both functions work the same. By using a chart expression we count rows in a table. First you need to create a chart in the QlikView application.

In my previous article I discussed how to create a chart in a QlikView application.

Creating a chart in QlikView application

Then start these steps.

Step 1: Create a chart

Now again create a chart for counting rows in a table.

chart

Step 2: General Window

In this window is an option for a pivot table. Select Pivot Table and click on the Next button.

General

Step 3: Add dimension

In this window we add a dimension because dimensions describe calculated data and click on the Next button.

dimension

Step 4: Edit expression

In this window we perform an aggregate function with any one dimension and click on the OK button.

edit

Step 5: Expression window

Then this window will be opened and click on the Finish button.

Expression

Step 6: Final window

Then you will see this chart and also see the number of total rows in a table. This chart shows total rows (10).

final1

Summary

This article described the use of a chart expression to get a simple count of rows in a table.