topic Wrong count totals ? in QlikView

Wrong count totals ?

Fri, 03 Aug 2012 15:06:51 GMT

Hi all,

I have a simple table showing a count of work activities by type (down) and month (across). The expression is simply: count(distinct activity). I am using distinct because for each day there are two records, morning activity and afternoon activity, but I am not interested in this split to be shown in this table.

The issue is that if I add totals they are wrong. What i am looking for is just the sum of the row values (counts), but the totals are different.

Any clue ? how can I get the right totals ? I have noticed that in object Properties totalization rules are grayed when the expression is a count, I don't understand why.

Thanks for helping.

Nik

I am using Ver. 9

Re: Wrong count totals ?

Anonymous — Mon, 06 Aug 2012 02:17:34 GMT

Hi,

Since you're using a pivot table the different types of expression totals are greyed out.

The distinct count totals might be different since a certain activity might show up for both Jan and Feb but since we only calculate distinct values the total will just show 1 instance for the activity.

You'll want to use aggr() in your expression to aggregate the counts over each dimension combination and then sum them up. Something along the lines of:

sum(aggr(count(distinct activity), type, month))

Re: Wrong count totals ?

Anonymous — Tue, 20 Jan 2015 09:12:24 GMT

Good Answer