Take record counts of tables

[Anonymous]

Hello all,

I have a requirement like below.

In a database I have tables almost 20 and i want to display records count in dashboard.

Like

select count(*) from dim_orders

Result 200

In Qlikview

Orders: 200

like way I have to display for all tables.

Please help me how to proceed on this

Regards

Kumar

[engishfaque]

Dear Kumar,

Kindly find attached app for counting records in table using Sub Routine.

Kind regards,

Ishfaque Ahmed

[Anonymous]

Thanks Ahmed. But it is dealing with only QVD's.

My requirement is if I connect to data base, I want to show record counts corresponding to each table.

[Anonymous]

Hi All,

Please suggest or give me sample script to get record counts in each table when it is connected to data base especially with postgre

[jonathandienst]

>> My database is now postgre, will it work for that data base.

I don't think so, as it relies on the SQL Server system views.