topic Re: Mod() Function in QlikView

Mod() Function

mphekin12 — Thu, 09 Jul 2015 15:27:48 GMT

Can someone explain how mod(-4,3) returns a value of 2?

Thank

robert_mika — Thu, 09 Jul 2015 15:53:44 GMT

When working with negative number we are looking for value larger absolute value.

In this case -6 is larger than -4

and

-4=-6+2

mphekin12 — Thu, 09 Jul 2015 16:10:56 GMT

Robert,

Thanks for your reply but I am still not clear. Where are you getting the -6 from?

robert_mika — Thu, 09 Jul 2015 17:02:05 GMT

Is the first number greater than 4 divided by 3.

Qrishna — Thu, 09 Jul 2015 17:06:30 GMT

I think it's working like the Excel function, and this function can be (according to Excel Help) evaluated like:

MOD(n, d) = n - d*INT(n/d)

So:

mod(-4,3) = -4 - 3*(-2) = +2

mphekin12 — Thu, 09 Jul 2015 17:59:23 GMT

Krishna,

Thanks for the explanation, now it makes sense!