27 Replies Latest reply: Jun 3, 2014 6:01 AM by Rémi PORTIER RSS

How to get a simple count of rows in a table

peter.turner

 

Hello Everyone,

I'm trying to find a simple way to make my table title show the number of rows in the current selection.

Usually I just count one of my ID fields such as count(MY_ID), but I'm looking if there is a built in function I can use instead?
Similar to the "Sum of Rows" feature for an expression, just need a simple count of the number of rows that are shown on screen.

Does QV have a built in function for this sort of thing or anyone have any ideas?
The dataset is large with 6million+rows.


Thanks,
Peter.