topic count records in QlikView

count records

Mon, 23 Jan 2012 10:55:51 GMT

I fetched records to a table-box. I don't know which field is the primary key.Now I want to find the no. of records fetched.

How can I do this?

count records

stephencredmond — Mon, 23 Jan 2012 11:01:12 GMT

Hi,

You can make a "primary key" for this purpose if you know which of the fields make the results unique:

Count(Distinct Field1 & Field2 & Field3)

Regards,

Stephen

count records

lalitinmbd — Mon, 23 Jan 2012 11:04:05 GMT

Use a variable

Let Rows=NoofRows(TableName);

$(Rows) will give you the no of records in the table.

count records

stephencredmond — Mon, 23 Jan 2012 11:10:10 GMT

Hi,

NoofRows(TableName) is a script function.

NoofRows() is a chart function so won't work in a table box.

Regards,

Stephen

count records

lalitinmbd — Mon, 23 Jan 2012 12:06:59 GMT

Try using Recno() in the script.

count records

nstefaniuk — Mon, 23 Jan 2012 12:23:54 GMT

You can add a field "ROW_COUNT" with the value 1 in your table and sum(ROW_COUNT). More efficient than count(distinct ...) and you don't need to build a key on the fly. Moreover it can be dynamic with selections in application.

count records

Tue, 24 Jan 2012 07:01:52 GMT

Hi,

I'm new to Qlikview. Please tell me how to add a field in an already existing table-box with data.

I tried adding an inline table to the script with LOAD * INLINE[row_count];

However when I add this to the table-box, the table-box does not show any value.

Thanks,

count records

vijay_iitkgp — Tue, 24 Jan 2012 07:11:10 GMT

Hi,

If you click on top of Table box it will show you total rows at bottom . If you want to show the number of rows fetched then you can use function RowNo() as Rows in your extract and show it in tablebox.

Load

RowNo() as Row

From table.qvd;

Hope this will help.

Vijay

count records

Tue, 24 Jan 2012 07:14:45 GMT

Thank you all,

I got the solution by adding Rowno() function as suggested by Vijay