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.