records

[satishqlik]

Hi,

I want to show feilds which is having records along with table name.

In straight table,
tablename is the dimension and expression corresponding fields(which is having records)

How to accomplish this?

[vinieme12]

See this script from HELP at the end of the page

For t = 0 to NoOfTables() - 1 //Iterate through the fields of table For f = 1 to NoOfFields(TableName($(t))) Tables: Load TableName($(t)) as Table, TableNumber(TableName($(t))) as TableNo, NoOfRows(TableName($(t))) as TableRows, FieldName($(f),TableName($(t))) as Field, FieldNumber(FieldName($(f),TableName($(t))),TableName($(t))) as FieldNo Autogenerate 1; Next f Next t;

Table functions ‒ QlikView

[ramasaisaksoft]

Hi Satish,

System table fields will explain you about this

New sheet object-->table box-->click the check box System fields-->add the below columns

$Table,$Field,$Rows

even straight table also you can add these fields as it is and give expression as =1

then go to Presentation tab and hide the expression column.

so that you will see only 3 columns table ,field name,Rows count

[awhitfield]

Use a table with the field as shown below:

HTH

Andy