NoOfTables() Function

[Anonymous]

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

[ashfaq_haseeb]

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

[qlikmsg4u]

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

[Anonymous]

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...

[qlikmsg4u · Accepted solution]

NoOFTables() is a script function.

Hence you can't find it in UI functions.

[sasiparupudi1]

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

[Anonymous]

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