topic Re: count in QlikView

count

Tue, 25 Oct 2016 04:32:17 GMT

I have created adhoc report , where user can select up to 4 dimensions & expressions from dimension , expression list boxes at a time.

once user will select dimension & expression from list boxes , table chart will show the data for those selections.

I want to capture how many rows is available in table so that user will come to know , how many rows is there in table.

please let me know how i can get the row count of table in text object according to selection of dimension & expression by user.

Re: count

robert_mika — Tue, 25 Oct 2016 05:11:54 GMT

Use Statistic Box object:

Re: count

johnw — Tue, 25 Oct 2016 16:37:27 GMT

One simple way to show the number of rows is to add an expression, Row Count, with a value of 1, and with a total Mode of Sum of Rows.

That's not in a text object, of course. I believe the expression for a text object is going to depend heavily on how you've implemented your adhoc report.

Re: count

kaushiknsolanki — Thu, 27 Oct 2016 18:41:19 GMT

Hi,

You can also use the dynamic count function which will count the numbers of distinct values.

Lets assume that your Dimension Field (from where users are selecting the Dimension for chart) is _dimension.

Then you can use below expression in the Caption of chart to get the numbers of records.

=Count(Distinct $(=Concat(_dimension,'&')))

Regards,

Kaushik Solanki