Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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
Honored Contributor II

Re: Table and field calculation.

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

Re: Table and field calculation.

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
Honored Contributor II

Re: Table and field calculation.

Hi.

Have you checked the system fields ?

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

Community Browser