Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Ways to number of rows in current dataset.

Hello Everyone,

Is there any way to find the number of rows in a dataset that I am currently using to build the application.

Because I have testing an application and the user's dataset has 21000 rows and he asked me what is

my testing dataset. But I am directly using the application to test the result, so I have no clue nor do I

have any understandings how to do it.

Please help,

Regards,

Bikash

6 Replies
jduenyas
Contributor III

Ways to number of rows in current dataset.

Create a Table Object and insert the fileds $Table and $Rows.

Thant will show you how many tables and how many rows for each are in your database

Not applicable

Ways to number of rows in current dataset.

In your load add in a field called Count_Up and put a 1 in it then jsut sum(Count_Up) to get number of records

Not applicable

Re: Ways to number of rows in current dataset.

I know the two fields $table and $rows but how can I adress them to read values from them in the script?

What Is the name of the underlying System-Table?

Kind regards

Chris

Re: Ways to number of rows in current dataset.

You can't access $Table & $Rows in the script. They don't exist until script end.

In script, you can get the number of rows using the function:

NoOfRows('tablename')

-Rob

Not applicable

Re: Ways to number of rows in current dataset.

Hope it helps:

1. To find no of rows in a previously loaded table

NoOfRows('TableName')

2. To find no of fields in a previously loaded table

NoOfFields('TableName')

3. To find no of tables loaded

NoOfTables()

Not applicable

Re: Ways to number of rows in current dataset.

Please let me know which of the solution makes sense...

Community Browser