Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

Can this be done?

I need to create a summary overview (table) to display the number of records in each table.  The numbers should be updated as the data is filtered.  I have five tables: A, B, C, D, E, F.  The display should look like this:

A             100

B                 5

C          1,150

D               21

E               10

Any suggestions are appreciated.


Frank

1 Solution

Accepted Solutions
Highlighted
Partner
Partner

Franck,

Do a Listbox with Expression or a simple Table...

Like the attached file.

François

View solution in original post

8 Replies
Highlighted
Partner
Partner

Hi there.

Make sure each of your tables have an unique ID field (you can create one with the AutoNumber() family of functions if it doesn't exists) so you can use count(distinct ID) to find out the number of records on each table.

Kind regards,

Ernesto.

Highlighted
Partner
Partner

Hi Franck,

Use the systems Fields like $Table and $Rows.

See the attached file to get an example.

Have fun with QV,

François

Highlighted
Partner
Partner

I can get the count for each table, but how can I display them all together?

Highlighted
Partner
Partner

Franck,

Do a Listbox with Expression or a simple Table...

Like the attached file.

François

View solution in original post

Highlighted
Partner
Partner

How can I restict the number of tables that are appearing?  For example, I might have 10 tables in the model, but only want to show 5.

Also, the number of rows needs to change as the data is being filtered.

Highlighted
Partner
Partner

Franck,

With the systems fiels, I think you can't restrict (i.e. with set analysis)...

I will search more, but...

Regards,

François

Highlighted
Partner
Partner

Francois

I think I have a work around.  I created an inline table to show the table names that I want to display.  I create a chart (straight table) and used a calculated expression to count the key for each table.

It works, but is there a bettter way?

Highlighted
Partner
Partner

Franck,

Good work !

Have fun with QV,

François