Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
curiousfellow
Creator II
Creator II

count number in percentage of total count

I have two groups of salesmen, A and B

Total sales per salesman per month  is set into a class

Now I want to know the number of salesman per group per class per month/ in a percentage of total number of salesman per group per month.

I can't succeed in counting the number of salesman in the divider (per group,per month)

Edit : found the correct expression for a pivot table :

=count(distinct name)/aggr(nodistinct count(distinct name),month,group)

Now I have to put it in a chart.

1 Reply
sunny_talwar

I think you issue is the calculated dimension. Is there anyway you can create the classes in the script?