Sum if count distinct result greater than value

[doganatasoy]

Hi All,

I am quite new in qlik view, and I got below expression to calculate Worker performance.

My dimension is Worker 

(sum(if([Process Code]='107', [Manufactured Qty])))
/
(sum(if(Deleted='No',[Planning Qty])))

I want to run this function for who worked more than 50 work orders. (count(distinct(WO))>50

Regards,

Dogan

[__alebra__ · Accepted solution]

Hi , 

try in this way:

if (count(distinct(WO))>50, sum(if([Process Code]='107', [Manufactured Qty])) / sum(if(Deleted='No',[Planning Qty])))

but you will have better performance if you use the set analysis:

if (count(distinct(WO))>50, sum({<[Process Code]= {'107'}>} [Manufactured Qty]) / sum({<Deleted={'No'}>}[Planning Qty]))

Ciao

Ale

[doganatasoy]

Set analysis worked, thanks for your help.

Regards,
Dogan