topic Re: Need Help in QlikView

Need Help

Nagaraju_KCS — Sun, 21 Jun 2015 07:57:50 GMT

HI Community,

I am confusing with Mod() function...

Example:

Mod(15,3) is 0 because 15/3 is 5 (5*3=15) with reminder 0 --------------> this is OK

But,

mod( 7.5,2 ) is 1.2 because 7.5/2 is 3 (3*2=6) with reminder 1.5 ------> but in Qlikview it returns NULL value

and mod( -4,3 )is -1 because -4/3 is -1 ------> But in Qlikview it returns 2

any Logic here????

Please anyone give explanation...

Re: Need Help

Anonymous — Sun, 21 Jun 2015 08:13:48 GMT

It is explained in the QV Desktop Help, pasted in below.

mod(x1 , x2)

Mathematical modula function. Both parameters must have integer values. x2 must be greater than 0. The result is the non-negative remainder of an integer division.

Examples:

mod( 7,2 ) returns 1

mod( 7.5,2 ) returns NULL

mod( 9,3 ) returns 0

mod( -4,3 ) returns 2

mod( 4,-3 ) returns NULL

mod( -4,-3 ) returns NULL

Re: Need Help

Nagaraju_KCS — Sun, 21 Jun 2015 08:31:43 GMT

Hi Bill,

I Understood this one..

What is the Logic for these two??

Suppose Mod(x1,x2) here X2 greater than 0.

mod( 7.5,2 ) returns NULL

mod( -4,3 ) returns 2

Re: Need Help

MarcoWedel — Sun, 21 Jun 2015 08:42:54 GMT

Use fmod() for decimal numbers

Regards

Marco

Re: Need Help

MarcoWedel — Sun, 21 Jun 2015 21:22:38 GMT

hope this helps

regards

Marco

Re: Need Help

Nagaraju_KCS — Mon, 22 Jun 2015 15:32:05 GMT

Hi Wedel,

May be it works like this...

Formula: (Excel Formula)

Mod(A, B) =A - B * Int (A / B)

Mod(-4,3) = -4 -3 * (-2) =2

Suppose INT(A/B) means---->Rounds down

like INT(8.9) = Rounds 8.9 down= returns 8

INT(-8.9)= Rounds -8.9 down = returns -9