topic Calculation integer divided by time in QlikView

Calculation integer divided by time

amber2000 — Wed, 25 Nov 2020 16:16:04 GMT

Hi Everybody,

I have another small problem with a calculation. (I'm working with Qlikview version 12)

From the source I receive a value in seconds for the field PA_SecondsWorked (I format this to hours in the script and treat it as an interval type)

The second field PL_Nr_Of_Cases contains integer values.

I want to calculate the productivity but it's giving 0 back as result:

[PL_Nr_Of_Cases] / [PA_SecondsWorked]

Somewhere I'm doing something wrong but I don't see it, can any of you help please?

I'm attaching the qvw to see what I've been doing.

Kind regards,

Monique

stigchel — Wed, 28 Sep 2016 14:26:50 GMT

Hi Monique,

You need an aggregation function like Sum() because there are two possible values for the one warehouse code so e.g.

Sum([PL_Nr_Of_Cases]) / Sum([PA_SecondsWorked])

amber2000 — Wed, 28 Sep 2016 15:50:08 GMT

Hi Piet Hein,

This does the trick, thanks a lot for the great help.

Kind regards,

Monique