topic NoOfTables() Function in QlikView

NoOfTables() Function

Anonymous — Wed, 22 Jul 2015 11:19:28 GMT

Good day,

Mention is made of the NoOfTables() function in this forum as well as in the help files, however it does not seem to exist in the QlikView client application. Am I missing something ?

Kind regards

Edwin

Re: NoOfTables() Function

ashfaq_haseeb — Wed, 22 Jul 2015 11:23:17 GMT

Hi,

Text quoted from Qlikview help

NoOfTables()

Returns the number of tables previously loaded.

TableName( 'TableNumber' )

What version of Qlik you use.

May be you need to upgrade your Qlik version.

Regards

ASHFAQ

Re: NoOfTables() Function

qlikmsg4u — Wed, 22 Jul 2015 11:24:22 GMT

NoOFTables() is a script function.

However, if you want use the output of the function create a variable

Like Let v1 = NoOfTables();

and use the variable in UI

Re: NoOfTables() Function

Anonymous — Wed, 22 Jul 2015 11:29:12 GMT

Hi Ashfaq,

Yes I saw that in the help file and coded it as such but it's not recognised as a function.

I am using Version 11.20.12235.0

It is also not in the list of "All Functions"

Hence my confusion...

Re: NoOfTables() Function

qlikmsg4u — Wed, 22 Jul 2015 11:42:43 GMT

NoOFTables() is a script function.

Hence you can't find it in UI functions.

Re: NoOfTables() Function

sasiparupudi1 — Wed, 22 Jul 2015 11:43:33 GMT

Hi Edwin

The table functions such as NoOfTabels(),NoOfFields() are all script level functions and are not accessible to tthe client. However you could use some system fields in the client and they all start with a $

ex: $Rows, $Table

HTH

Sasi

Re: NoOfTables() Function

Anonymous — Wed, 22 Jul 2015 11:44:21 GMT

Thanks,

Yes I saw now it works in the script but not UI.

I managed to get what I wanted to do, thanks for the replies I do appreciate it.

Kind regards

Edwin