Solved: How to get a simple count of rows in a table - Qlik Community

peter_turner · ‎2010-06-23

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.

	
		OSZAR »

seanbruton · ‎2025-05-28

Hi Peter,

Try this solution, I hope it helps you.

I have also experienced the same issues you are having in the past. It becomes problematic when your ID field which you are counting on is also a key field in the data model.

So what I found that works well is to add a field eg; 1 as ind1 to the table. Then sum this field or count if you wish.

Regards

Sean

View solution in original post

peter_turner · ‎2025-05-29

Hello all!

I wanted to close this post down, as lots has changed in the 15 years since I posted it.

There have been lots of great replies and suggestions, so your answer will depend on your specific app. These days i generally would suggust to use flags in the data model such as value 1, which you can count/sum or use in set analysis etc etc, lots of other community posts on the advantages of this.

Also, add steps into the data loading script to clean/model the data, so your UI dashboard can show actionable information, and not simply a replacement for excel.

View solution in original post

Report Inappropriate Content · ‎2010-06-23

Hi Peter

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.

Good luck,

	
		OSZAR »

peter_turner · ‎2010-06-23

Hi Nigel,

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.

Peter.

	
		OSZAR »

Report Inappropriate Content · ‎2010-09-24

I'm having trouble with this function as well. Were you ever able to find an answer to this?

	
		OSZAR »

Report Inappropriate Content · ‎2010-09-24

Hi there, try using the total qualifier, like this:

rowno(total)

That should do the trick.

Regards

	
		OSZAR »

Report Inappropriate Content · ‎2010-11-16

That worked! Thank you!!!

	
		OSZAR »

Report Inappropriate Content · ‎2010-11-26

Hi

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.

Any ideas?

Thanks

	
		OSZAR »

johnan · ‎2010-11-27

Hi,

You can try to set a counter in the script:

'1' as RowCounter

Very simple

	
		OSZAR »

prieper · ‎2010-11-27

Why not using a simple count on a field, which is available in all records?

='This table has ' & COUNT(Keyfield) & ' records'

HTH
Peter

	
		OSZAR »

Report Inappropriate Content · ‎2010-11-29

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'

Any suggestions

	
		OSZAR »