Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Table and field calculation.

Hi,

I loaded 25 tables and there are many fields and rows on this table i want to store this values in any variable like.

Total table loaded.

Total fields available.

Total rows available.

Thanks,

3 Replies
whiteline
Master II
Master II

Hi.

There are System fields with info that you want (toggle checkboxes 'Show System Fields' on dimension tab or expression editor).

Also there are usfeul functions like NoOfRows() and so on.

Not applicable
Author

Hi,

Thanks, but i have 25 tables and i want to make a variable that contains the total rows available in the tables like

ex:- For three table individually rows( ) available.

Thanks,

whiteline
Master II
Master II

Hi.

Have you checked the system fields ?

Isn't a tablebox with fields $Table and $Row what you want ?