Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
Not applicable

Pivot chart count

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

1 Solution

Accepted Solutions
Not applicable

Pivot chart count

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.

View solution in original post

2 Replies
Not applicable

Pivot chart count

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.

View solution in original post

Not applicable

Pivot chart count

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