Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

curiousfellow
Contributor 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

Re: count number in percentage of total count

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