topic Can this be done? in QlikView

Can this be done?

fcecconi — Thu, 22 Jan 2015 18:26:49 GMT

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

Re: Can this be done?

consenit — Thu, 22 Jan 2015 18:34:38 GMT

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.

Re: Can this be done?

francoiscave — Thu, 22 Jan 2015 18:35:24 GMT

Hi Franck,

Use the systems Fields like $Table and $Rows.

See the attached file to get an example.

Have fun with QV,

François

Re: Can this be done?

fcecconi — Thu, 22 Jan 2015 18:37:45 GMT

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

Re: Can this be done?

francoiscave — Thu, 22 Jan 2015 18:42:48 GMT

Franck,

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

Like the attached file.

François

Re: Can this be done?

fcecconi — Thu, 22 Jan 2015 18:43:51 GMT

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.

Re: Can this be done?

francoiscave — Thu, 22 Jan 2015 18:55:57 GMT

Franck,

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

I will search more, but...

Regards,

François

Re: Can this be done?

fcecconi — Thu, 22 Jan 2015 19:32:58 GMT

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?

Re: Can this be done?

francoiscave — Fri, 23 Jan 2015 07:55:50 GMT

Franck,

Good work !

Have fun with QV,

François