topic Re: Division formula issue in Archived Groups

Division formula issue

Tue, 22 Jul 2025 17:59:49 GMT

Hello,

I'm currently still learning about Qlikview but what seemed to be a simple formula turned out to be an issue for me.

I'm trying to calculate the rate of two sum formulas.

My two formulas, sum(A) and sum(B), are able to output data. However, when I want to divide them, my straight table outputs 0.

The formula I have is: Div(sum(A),sum(B)).

Any help would be appreciated. Thank you in advance!

sunny_talwar — Wed, 30 Dec 2015 18:20:43 GMT

May be try one of these:

Sum(A)/Sum(B)

Sum(A/B)

maxgro — Wed, 30 Dec 2015 18:21:53 GMT

did you try?

sum(A) / sum(B)

Wed, 30 Dec 2015 18:23:31 GMT

Yes, and the output is still 0

sunny_talwar — Wed, 30 Dec 2015 18:24:05 GMT

In addition, Div function outputs a integer so if your Sum(A) < Sum(B) (both positive numbers) you will see 0

maxgro — Wed, 30 Dec 2015 18:25:10 GMT

could you post your .qvw?

sunny_talwar — Wed, 30 Dec 2015 18:25:27 GMT

See if the Num function helps:

Num(Sum(A)/Sum(B), '##.00000000')

Wed, 30 Dec 2015 18:33:37 GMT

Thank you, this worked perfectly!

sunny_talwar — Wed, 30 Dec 2015 18:34:34 GMT

Awesome , glad it did