How can total number of records can be shown in the table?

[#1]

I know by default the total number of records are being shown on the bottom right of the Qlikview window but how can total number of records can be shown in the table (top row or on the bottom)?

[#2]

I'm not sure I undestand what You are asking about but have you checked :

[nilesh_gangurde]

Take a straight table and add dimension and expression as you want.

Then add 1 more expression as "1".

And then Select the Expression tab => Total Mode => select "Numeric Count" of Rows.

Then in the total you will get the total no of records in the table.

This counts all the records including the record having "ZERO" values.

Regards,

Nilesh Gangurde

[#4]

Hi Nilesh,

Thanks for your reply.

I got the total number of records but:

1. Now app table displayes 1 against every records which looks little ugly...right? and If I hide this then total will not be shown either.
2. this expression is not fitting in my logic. It has messed up my other expressions.

"Or am I doing something wrong?"

What I want is to show the total count of records which I get after apply my filters.

Is there a way to add one more colum "sequence no." in my table?

If it is possilbe can someone help me how can I do that?

Thanks,

TA

[MayilVahanan]

Hi

     Can i know which chart are you using?

     If straight table,Select ur expression then in Expression tab => Total Mode => select "Numeric Count" of Rows. or Total Count of Rows.

     or

     use RowNo(total) as expression and give conditional(count(currentselections()) > 0 , it hide rowno(total) first..

     Hope it helps