topic How to count rows from conditional chart table fields in text object in QlikView

How to count rows from conditional chart table fields in text object

Fri, 29 May 2015 14:15:29 GMT

Hello All,

I am wondering how do I count the number of rows in a text object based on a selected conditional dimension in a chart table? As you can see below, I would like the count of rows to display in that text box. The conditional dimensions are controlled by the list boxes on the left. This allows the user to build a custom table of data to then export to excel. This whole point of this is to warn the user when the selections are reach 1 million rows, so they do not export to much data to excel.

Re: How to count rows from conditional chart table fields in text object

Gysbert_Wassenaar — Fri, 29 May 2015 16:46:52 GMT

See attached example for an approach that usually gives a reasonable estimation. The result can be higher than the number of rows in the chart because of zero/null suppression and reduced sets resulting from set analysis expressions.

Re: How to count rows from conditional chart table fields in text object

Tue, 02 Jun 2015 18:04:40 GMT

Hey,

I put the code below in my text object. I am just getting a zero.

=sum(aggr(1, $(=concat(%Dimension, ',' ))))

This is the formula I use for the conditional dimensions/expressions to appear when the user selects them.

SubStringCount(Concat(%Dimension, '|'), 'Hospital') and GetSelectedCount(%Dimension) > 0

Re: How to count rows from conditional chart table fields in text object

Gysbert_Wassenaar — Wed, 03 Jun 2015 07:51:45 GMT

Do you have any field names containing spaces (or other special characters)? If so, try =sum(aggr(1, $(=concat('[' & %Dimension & ']', ',' ))))

Can you post a qlikview document that demonstrates the problem?

Re: How to count rows from conditional chart table fields in text object

cbaqir — Fri, 04 Dec 2015 17:56:03 GMT

Gysbert,

I am using sum(aggr(1, $(=concat(_dimension, ',' )))) to count the lines in my Ad Hoc table but the numbers don't match. It gives me 335, for example, but only exports 152. Any thoughts without me posting a sample?

Thanks,

Cassandra