topic Re: Straight Table Row Count in QlikView

Straight Table Row Count

Johnnyg248 — Fri, 08 Mar 2019 18:39:15 GMT

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

bharathadde — Fri, 08 Mar 2019 18:54:22 GMT

Can you share your Excel File

rwunderlich — Sat, 09 Mar 2019 01:18:28 GMT

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

Johnnyg248 — Mon, 11 Mar 2019 13:52:20 GMT

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

Thanks!