topic Re: Fuctionality of mod() in QlikView

Fuctionality of mod()

raghvendrasingh — Wed, 21 May 2014 11:14:27 GMT

Hi All,

1.what is process of mod() function in qlikview,if we give the mod(-5,3) then it returns 1,but in general mathematics it gives -2,

2.why mod(3,-2) gives NULL

please anyone give the clarification about mod() function.

Regards,

Raghvendra

Re: Fuctionality of mod()

Wed, 21 May 2014 11:19:02 GMT

QlikView mod function works only with integers.

To get the right output of ur examples use fmod function.

Like fmod(-5,3) and fmod(3,-2)

Hope this will give u required output.

Re: Fuctionality of mod()

vipin_mishra479 — Wed, 21 May 2014 11:25:59 GMT

Hi Raghvendra,

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.

regards,

vipin

Re: Fuctionality of mod()

raghvendrasingh — Wed, 21 May 2014 11:43:34 GMT

hi fiends,

i want the programmig logic of mod() function.not the features.how it internally works..