Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
satishqlik
Creator II
Creator II

records

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?

3 Replies
vinieme12
Champion III
Champion III

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

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
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
Partner - Champion
Partner - Champion

Use a table with the field as shown below:

HTH

Andy