topic records in QlikView

records

satishqlik — Wed, 25 Nov 2020 16:16:04 GMT

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?

Re: records

vinieme12 — Wed, 26 Apr 2017 09:18:10 GMT

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

Re: records

ramasaisaksoft — Wed, 26 Apr 2017 10:40:15 GMT

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

Re: records

awhitfield — Wed, 26 Apr 2017 11:44:58 GMT

Use a table with the field as shown below:

HTH

Andy