Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

NoOfTables() Function

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

1 Solution

Accepted Solutions
Highlighted
Specialist
Specialist

Re: NoOfTables() Function

NoOFTables() is a script function.


Hence you can't find it in UI functions.

View solution in original post

6 Replies
Highlighted

Re: NoOfTables() Function

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

Highlighted
Specialist
Specialist

Re: NoOfTables() Function

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

Highlighted
Partner
Partner

Re: NoOfTables() Function

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"NoOfTables.tiff

Hence my confusion...

Highlighted
Specialist
Specialist

Re: NoOfTables() Function

NoOFTables() is a script function.


Hence you can't find it in UI functions.

View solution in original post

Highlighted
Master III
Master III

Re: NoOfTables() Function

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

Highlighted
Partner
Partner

Re: NoOfTables() Function

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