topic Re: Division Command in QlikView

Division Command

Mon, 15 Jun 2015 05:24:57 GMT

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

PrashantSangle — Mon, 15 Jun 2015 05:29:14 GMT

Hi,

What error you are getting for your expression??

try

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

[Wit Quantity Second Unit] / [Factor]

Regards

sasiparupudi1 — Mon, 15 Jun 2015 06:13:26 GMT

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])

Mon, 15 Jun 2015 06:32:57 GMT

thanks