Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
Johnnyg248
Contributor III
Contributor III

Straight Table Row Count

Trying to put row count of  straight table into title

How do I get the row count to be what is actually displayed in the straight table

I tried putting the following

='Query Results (' & (Count(email)) & ' Rows )'

If I export the straight table to excel it has 20654 records (not including the header row)

 

However

Query Results (1211 Rows) appears in title

 

Not sure where 1211 is coming from

 

 

1 Solution

Accepted Solutions
rwunderlich

You will need to specify all the dimensions of your table as a concatenated string and use distinct. 

Count(distinct email & date & name)

assuming email, date, name are your dimensions.

-Rob

View solution in original post

3 Replies
bharathadde
Creator II
Creator II

Can you share your Excel File

rwunderlich

You will need to specify all the dimensions of your table as a concatenated string and use distinct. 

Count(distinct email & date & name)

assuming email, date, name are your dimensions.

-Rob

View solution in original post

Johnnyg248
Contributor III
Contributor III
Author

Listing all dimensions  within the count(distinct) did the trick

 

Thanks!