Qlik Table Distinct Total Percentage

[andrewc]

I am sorry, this should be basic stuff!

Looking at the below I am wanting to create a new column [TOTAL WORKLOAD] / [DISTINCT OPERATORS] 

Formula's for each below:

[DISTINCT OPERATORS] = count(distinct OPERATORID)

[TOTAL WORKLOAD] = sum(WORKLOAD)

I was hoping this would work, but nup ...

sum(WORKLOAD) / count(TOTAL <DATE> distinct OPERATORID)

The first result should be ~5,955

Thanks!

[abhijitnalekar]

Hi @andrewc ,

Please try

Column(1)-Column(2)

1 and 2 would be your column position in the table.

[Or · Accepted solution]

Why not just sum(WORKLOAD) / count(distinct OPERATORID) ?

[andrewc]

Uuurgh! I should have started with simple! Thanks Or!