topic Pivot chart count in QlikView

Pivot chart count

Fri, 02 Jul 2010 13:34:28 GMT

I've seen a similar question to this on the forum, but it didn't solve my query.

I have a pivot table.

On the left, two dimensions: weekname then by sales person.

Along the top, one dimension: communication type (e.g. email, meeting, etc).

I simply want to count the number of communications per sales person, per weekname and by communication type.

Count(commno) (where commno is the communication primary key) doesn't work. It returns the same value for every record per column.

aggr (count(distinct CommNo),WeekName,EmployeeName,Comm_Type) doesn't work either.

Help!!! I'm quite new to this.

Thanks

James

Pivot chart count

Fri, 02 Jul 2010 13:38:51 GMT

aggr (count( CommNo),WeekName)

aggr (count( CommNo),EmployeeName)

aggr (count( CommNo),Comm_Type)

I think this should work. If not, I dont have an idea.

Pivot chart count

Fri, 02 Jul 2010 13:58:57 GMT

Thanks for your reply. And apologies. There was a problem with my data upload (the above formulae do work).

I had mistyped one of the field names (Id rather than ID) and so rather than link, the two qvd files had performed a Cartesian product, hence why my data was wrong.

Thanks again

James