29 Replies Latest reply: Oct 30, 2017 5:16 AM by Rajasekhar . 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.