Discussion board where members can get started with QlikView.
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.
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
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
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?
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:
Hope it helps:
1. To find no of rows in a previously loaded table
2. To find no of fields in a previously loaded table
3. To find no of tables loaded
Please let me know which of the solution makes sense...