Discussion Board for collaboration related to QlikView App Development.
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.
The RowNo() function should provide this, so you can create your caption such as:
="This is my title, and there are this many rows: " & RowNo()
RowNo() without any parameters should give you total number of rows in the table.
Thanks for the reply, that was the sort of thing i was looking for - however i cannot get it to work, it allways returns 1.
I've used rowno() in the past in scripts to assign i row ID, but in the developer it seems to only return the number 1.
When I have tried to use either RowNo(total) or NoOfRows(total) in the chart caption, it always comes back with 1. Add it as an expression in the chart and it shows the correct value.
Thanks for that, but I am wanting to count the number of records displayed in the table.
The expressions has a formula which sets unwanted records to null thereby not showing certain records. I wanted to show the total number of records actually shown. The same would apply if a table is shown and one or more fields have the 'Omit row when field is null'