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

[Chanty4u]

Create the Straight table

Dimension: dim_orders

Expression: Count(dim_orders)

• field in rows count values total

[tyagishaila]

right click on dashboard

---> Select fields...  --->  Check Show System Fields ---> Select $Rows from system fields.

[maxgro]

there are 2 system fields, $Table and $Rows

[tamilarasu]

Hi Kumar,

Create a straight table with dimension as $Table and expression as $Rows. Now, you can see record count for all the tables.

[Anonymous]

Thanks all for sharing information.

here i am doing validations.

I am generating QVD and I want take record counts to the particular QVD. I want to compare those with data base table record count.

I want to display those two counts in QVW. This(counts should be updated dynamically) should happen for all QVD's and tables dynamically, if data gets refreshed.

[Chanty4u]

hope thsi thread will helps u

RE:after-before

[ramasaisaksoft]

Hi Kumar,

For finding Tables and Rows count ,Best way is System Table($Table,$Rows).

But here you will not get the correct results as it is Sql command why because in your QVD creation or Data model creation time you are used so many logics(Left join,Right join,Full outer Join...etc) so obviously your records count may be increased or decreased.

So if you want exact count of your records just check each and every table individually with ($Table,$Rows).

[MayilVahanan]

Hi

Try like this

Let TransactionQVD = QvdNoOfRecords('Transaction.qvd');

LOAD * Inline

[

FileName, records

Transaction.qvd, $(TransactionQVD)

];

[Anonymous]

Hi,

Thanks Mayil.

In this case, if I have 20 tables I have to declare 20 variable for each table rite?