NoOfRows() returns the number of rows in the current column segment in a table. For bitmap charts, NoOfRows() returns the number of rows in the chart's straight table equivalent.
If the table or table equivalent has multiple vertical dimensions, the
current column segment will include only rows with the same values as
the current row in all dimension columns, except for the column showing the last dimension in the inter-field sort order.
Information noteSorting on y-values in charts or sorting by expression columns in tables is not allowed when this chart function is used in any of the chart's expressions. These sort alternatives are therefore automatically disabled. When you use this chart function in a visualization or table, the sorting of the visualization will revert back to the sorted input to this function.
Syntax:
NoOfRows([TOTAL])
Return data type: integer
Arguments:
Arguments
Argument
Description
TOTAL
If the table is one-dimensional or if the qualifier TOTAL is used as argument, the current column segment is always equal to the
entire column.
Create a table visualization in a Qlik Sensesheet with Region and SubRegion as dimensions. Add RowNo( ), NoOfRows(), and NoOfRows(Total) as measures.
Result
Region
SubRegion
RowNo()
NoOfRows()
NoOfRows(Total)
Africa
Eastern
1
2
9
Africa
Western
2
2
9
Americas
Central
1
2
9
Americas
Northern
2
2
9
Asia
Eastern
1
1
9
Europe
Eastern
1
3
9
Europe
Northern
2
3
9
Eurrope
Western
3
3
9
Oceania
Australia
1
1
9
Explanation
In this example, the sort order is by the first dimension Region. As a result, each column segment is made up of a group of regions that has the same value, for example, Africa.
The RowNo() column shows the row numbers for each column segment, for example, there are two rows for the Africa region. The row numbering then begins at 1 again for the next column segment, which is Americas.
The NoOfRows() column counts the number of rows in each column segment, for example, Europe has three rows in the column segment.
The NoOfRows(Total) column disregards the dimensions because of the TOTAL argument for NoOfRows() and counts the rows in the table.
If the table was sorted on the second dimension, SubRegion, the column segments would be based on that dimension so the row numbering would change for each SubRegion.
Sheets are components of Qlik Sense apps. They present visualizations to app users so they can explore, analyze, and discover data. Sheets can be public or private.
A dimension is an entity used to categorize data in a chart. For example, the slices in a pie chart or the bars of a bar chart represent individual values in a dimension. Dimensions are often a single field with discrete values, but can also be calculated in an expression.
A dimension is a dataset in a data mart that forms part of the star schema. Dimension datasets hold the descriptive information for all related fields that are included in the fact table’s records. A few common examples of dimension datasets are Customer and Product. Since the data in a dimension dataset is often denormalized, dimension datasets have a large number of columns.
A measure is a calculation base on one ore more aggregations. For example, the sum of sales is a single aggregation, while the sum of sales divided by the count of customers is a measure based on two aggregations.