topic Re: Straight Table Row Count in QlikView

Straight Table Row Count

Johnnyg248 — Mon, 11 Mar 2019 15:42:22 GMT

I have a straight table that has 20 columns in it and is filtered by 6 list box selections

The selections I have made result in about 7000 rows being returned

If I change the selections the straight table is repopulated very quickly

I was hoping to put the number of rows in the title for which I posted and received a solution to do a list of dimensions in a count(disinct

='Query Results (' & (Count(distinct ID&FULL_NAME&LAST_NAME&FIRST_NAME&PREFIX&Member_Type&Category& BIRTH_DATE& COMPANY&ADDRESS_1&ADDRESS_2&CITY& state_province&zip& FAX& WORK_PHONE&email&EXCLUDE_MAIL& EXCLUDE_EMAIL)) & ' Rows )'

This results in an out of memory error. Guessing because this is being applied to every row prior to the filters ????

I was thinking of just putting the row count in a text box after the straight table has been populated

not sure how to get row count after straight table is populated

Thanks!!

Re: Straight Table Row Count

dplr-rn — Mon, 11 Mar 2019 17:09:11 GMT

The out of memory can be due to multiple things (poor data model etc.)

assuming its all ok

i can think of 2 ways

1- use GetSelectedCount to ensure filters have been selected before displaying the count expression

2- depending on your datamodel check if you can add the combination mentioned as a column in the fact table i.e. ID&FULL_NAME&LAST_NAME&FIRST_NAME&PREFIX&Member_Type&Category& BIRTH_DATE& COMPANY&ADDRESS_1&ADDRESS_2&CITY& state_province&zip& FAX& WORK_PHONE&email&EXCLUDE_MAIL& EXCLUDE_EMAIL as UniqueIDs

and do count distinct there

Re: Straight Table Row Count

marcus_sommer — Tue, 12 Mar 2019 12:10:57 GMT

I think you don't need to count over all 20 fields which are included within the table else those ones are enough which deliver an unique combination of your data. This means that maybe a count(distinct ID) or count(distinct ID&Category) might be working.

- Marcus

Re: Straight Table Row Count

Johnnyg248 — Tue, 12 Mar 2019 14:52:55 GMT

perhaps I should be using a table box instead?

Re: Straight Table Row Count

dplr-rn — Tue, 12 Mar 2019 15:07:55 GMT

Not sure what you mean.
Like marcus is suggesting, identify the unique id or combination which will indicate a row in your table

Re: Straight Table Row Count

marcus_sommer — Tue, 12 Mar 2019 15:37:13 GMT

If there are no measures within the table you could use a tablebox which would be in general more performant as a straight table but you would loose some possibilities to apply conditions and/or format something and so on. If it's helpful in regard to your wanted expression within the title - I think rather not.

Is these row-information only for you within the desktop client you could also look in the Qlik task-bar to see how many columns and rows an active object has.

- Marcus

Re: Straight Table Row Count

Johnnyg248 — Tue, 12 Mar 2019 20:11:51 GMT

Turns out there was error in my data model.

='Query Results (' & (Count(distinct ID)) & ' Rows )'

works now

Thanks!