Count of table

[prma7799]

Hi All,

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

Thanks

Prashant

[MK_QSL]

Create a variable

Let vNooftable = NUM(NoOfTables());

[Anonymous]

Hi Prashant,

Please elaborate on your question.

Regards

Neetha

[prma7799]

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

[Anonymous]

Hi,

Use:

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

Regards

Neetha

[prma7799]

Hi,

It is not showing me count of actual table.

Its showing me only 1.

Thanks

Prashant

[#7]

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

[#8]

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

[Anonymous · Accepted solution]

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.

[prma7799]

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

PM