Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Division Command

Hello,

i want to make a division like % in sql commands

suppose i want to have : 9/4 = (2,1)

what shoul i replace "sum( [Wit Quantity Second Unit] / [Factor] )" with?

Regards,

Mana

1 Solution

Accepted Solutions
sasiparupudi1
Honored Contributor III

Re: Division Command

If you need a modulo operation , use the following

for real numbers

fmod([Wit Quantity Second Unit] ,[Factor])

for integers

mod([Wit Quantity Second Unit] ,[Factor])

3 Replies

Re: Division Command

Hi,

What error you are getting for your expression??

try

sum( [Wit Quantity Second Unit]) /Sum( [Factor] )

or

[Wit Quantity Second Unit] / [Factor]

Regards

Regards,
Prashant Sangle
sasiparupudi1
Honored Contributor III

Re: Division Command

If you need a modulo operation , use the following

for real numbers

fmod([Wit Quantity Second Unit] ,[Factor])

for integers

mod([Wit Quantity Second Unit] ,[Factor])

Not applicable

Re: Division Command

thanks

Community Browser