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.

Step 2: General Window

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



Step 3: Add dimension

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

Step 4: Edit expression

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

Step 5: Expression window

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

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



Summary

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