topic Re: Dynamic count of fields for inline data in QlikView

Dynamic count of fields for inline data

Tue, 04 Aug 2015 18:23:22 GMT

Hi,

I have 20 table names. I want to show in a table

example:

Tablenames	no of fields		sno
a	45		1

I gave table names using inline ..

how do i count table . and how to match exactly.

Thanks

Re: Dynamic count of fields for inline data

Anonymous — Tue, 04 Aug 2015 18:27:48 GMT

hi Uma,

Please try:

Re: Count of table

Re: Dynamic count of fields for inline data

maximiliano_vel — Tue, 04 Aug 2015 18:28:41 GMT

Create a Straight Table with one dimension: $Table

Two Expresions:

Sum($Rows)
Sum($Fields)

Regards

Re: Dynamic count of fields for inline data

Anonymous — Tue, 04 Aug 2015 18:29:12 GMT

Yes you need to give below statement after loading all tables.

Let vNooftable = NUM(NoOfTables());

NoOfTables() is qlikview function ,counts tables loaded in to qliview memory.

Re: Dynamic count of fields for inline data

maxgro — Tue, 04 Aug 2015 18:51:55 GMT

Qlikview has some interesting system fields you can use to get the names and count of tables, fields, etc

and also make chart

If I understand you can use $Table and $Field

Re: Dynamic count of fields for inline data

Tue, 04 Aug 2015 19:35:27 GMT

My question was:

the table name ' a ' is from a sql db which has 4,500 records.

in line i am just giving the table name

Re: Dynamic count of fields for inline data

Anonymous — Tue, 04 Aug 2015 20:36:51 GMT

please elaborate on your question,its not clear

Re: Dynamic count of fields for inline data

maxgro — Tue, 04 Aug 2015 20:42:51 GMT

and you want to count the number of

- fields or records?

where?

- in the sql db or after you load the tables in the qlik db?

and if you loaded 30 tables in your qlik db

do you want to count the records or fields

- of the 30 tables

- or of the 20 table name you have in in inline

Re: Dynamic count of fields for inline data

Tue, 04 Aug 2015 20:52:22 GMT

I have a table 'a' from sql db which has 4,500 records.

like that I have 20 tables from a1 to a20 each of which has 4,500 records

now I want to give the names in in line and see how many total no of columns are there in each table.

dynamically taking the table names and processing it into for loop for count of columns for each table name.I even have them in .qvd formate.

If you suggest me which works good that really hepls me either inlilne or any query by using qvds

Re: Dynamic count of fields for inline data

maxgro — Tue, 04 Aug 2015 21:16:32 GMT

// table name (and also filename for qvd)

load * inline [

tablename

a11

a12

source

];

for i=0 to NoOfRows('T')-1 // start loop on tables (files)

let table=Peek('tablename', $(i), 'T');

let file = '$(table)' & '.qvd'; // qvd has the same name as table and suffix .qvd

trace table=$(table);

trace file=$(file);

let numoffields=QvdNoOfFields ('$(file)'); // num of fields of a qvd file

load

'$(table)' as tablename,

'$(numoffields)' as numoffields

AutoGenerate 1;

NEXT;