Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
curiousfellow
Specialist
Specialist

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?