28 Replies Latest reply: Sep 22, 2017 8:45 AM by Leandro Job Neto 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.