Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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