topic Set Analysis showing total wrong in QlikView

Set Analysis showing total wrong

Sahal — Sat, 12 Mar 2016 14:19:01 GMT

i have a chart that looks like this.

How do i sum() employment rate where time <> 0?

The user "Emelie Larsson" i don´t get in the chart below but her employment rate is still in the total.

here is my set analysis for employment rate.

even if the time field shows 0,00 and not 0 i have tried the same but that did not work

maxgro — Sat, 12 Mar 2016 15:35:41 GMT

try

sum({$ <Name={"=sum(Time)>0"}>} [Employment Rate])

perumal_41 — Sat, 12 Mar 2016 15:54:55 GMT

try

sum({$ <Name={"=sum({<WorkedFlag=[1]>}Time)>0"},[Employment Rate] -= ['10000']>} [Employment Rate])/100