Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
eanderson
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
qlikmsg4u
Specialist
Specialist

NoOFTables() is a script function.


Hence you can't find it in UI functions.

View solution in original post

6 Replies
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
Specialist
Specialist

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

eanderson
Partner
Partner
Author

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

qlikmsg4u
Specialist
Specialist

NoOFTables() is a script function.


Hence you can't find it in UI functions.

View solution in original post

sasiparupudi1
Master III
Master III

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

eanderson
Partner
Partner
Author

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