topic Re: Count of table in QlikView

Count of table

prma7799 — Thu, 19 Feb 2015 10:24:09 GMT

Hi All,

Is there any way to find out how table we using in QVW file.

Thanks

Prashant

Re: Count of table

MK_QSL — Thu, 19 Feb 2015 10:28:14 GMT

Create a variable

Let vNooftable = NUM(NoOfTables());

Re: Count of table

Anonymous — Thu, 19 Feb 2015 10:32:31 GMT

Hi Prashant,

Please elaborate on your question.

Regards

Neetha

Re: Count of table

prma7799 — Thu, 19 Feb 2015 10:58:52 GMT

Hi Neetha,

I want to find out how may table we are using in our dashboard application I have one dashboard with 2.5GB size and Nth number of table.

So I want to count of table which is use for QVW.

Thanks

Prashant

Re: Count of table

Anonymous — Thu, 19 Feb 2015 11:13:16 GMT

Hi,

Use:

NoOfTables() function - Returns the number of tables previously loaded.

Regards

Neetha

Re: Count of table

prma7799 — Thu, 19 Feb 2015 11:37:12 GMT

Hi,

It is not showing me count of actual table.

Its showing me only 1.

Thanks

Prashant

Re: Count of table

Thu, 19 Feb 2015 11:44:13 GMT

Hi Prashant,

the variable will need to go right at the end of your script, as it just gives the current number of loaded tables at that point.

hope that helps

Joe

Re: Count of table

Thu, 19 Feb 2015 11:47:26 GMT

Hi Prashant,

use below expression at end of your script. i.e Last Tab of you Script or Before Exit Script Function and do the reload you will get the number of table use in QVW File;

Let vNooftable = NUM(NoOfTables());

Regards,

Nandkishor Pandirkar

Re: Count of table

Anonymous — Thu, 19 Feb 2015 11:47:49 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: Count of table

prma7799 — Thu, 19 Feb 2015 12:06:17 GMT

Hi Neetha,

Thanks you very much for quick response..

but what about fields

Let vNoofFields = num(NoOfFields());

I am using above function but error is coming .

Thanks

Re: Count of table

Anonymous — Thu, 19 Feb 2015 12:10:05 GMT

Hi,

NoOfFields([ 'TableName ' ])

Returns the number of fields in a previously loaded table.

Let vNoofFields = num(NoOfFields('TableName '));

give table name in function.

Regards

Neetha

Re: Count of table

Thu, 19 Feb 2015 12:12:39 GMT

Hi,

Syntax for Numbers of Fields is

Let vNoofFields = num(NoOfFields('TableName'));

For Getting NoOfFields in Each Table you have to use loop

Regards

Nandkishor

Re: Count of table

prma7799 — Thu, 19 Feb 2015 12:16:54 GMT

Hi Nandkishor,

Can you give some example of loop for the same.

Thanks

Re: Count of table

Anonymous — Thu, 19 Feb 2015 12:22:30 GMT

Hi,

Try:

ODBC CONNECT TO [Excel Files;DBQ=ExcelFile.xlsx];

XlsTables:
SQLTables;
DISCONNECT;

LET vRows = NoOfRows('XlsTables');

FOR i = 0 TO $(vRows)-1

LET vSheetName = subfield(peek('TABLE_NAME', i,'XlsTables'),'$',1);
LET vFieldCount = noOfFields(TABLE_NAME);

$(vSheetName):
LOAD * ,
$(vFieldCount) as FieldCount
FROM [ExcelFile.xlsx]
(ooxml, embedded labels, table is '$(vSheetName)');

NEXT i

DROP TABLE XlsTables;

Re: Count of table

Thu, 19 Feb 2015 12:24:45 GMT

Hi,

You can use below code to get No Of Field

LET vNooftable= NUM(NoOfTables());
Let vNoofFields=0;
FOR i= 1 to $(vNooftable) step 1

Let vNoofFields = vNoofFields + num(NoOfFields(TableName(i-1))) ;

Nandkishor Pandirkar