Qlik Community

Qlik Deployment Framework

This group hosts information related to the Qlik Deployment Framework (QDF). Providing best practices, libraries and utilities that facilitate the recommended setup and management of QlikView or Qlik Sense environments. An understanding of the Qlik platform is recommended before joining this group. Download QDF and documentation here: https://github.com/QlikDeploymentFramework/Qlik-Deployment-Framework/releases

Highlighted
Not applicable

Division formula issue

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!

1 Solution

Accepted Solutions

Re: Division formula issue

See if the Num function helps:

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

8 Replies

Re: Division formula issue

May be try one of these:

Sum(A)/Sum(B)

or

Sum(A/B)

MVP
MVP

Re: Division formula issue

did you try?

sum(A) / sum(B)

Not applicable

Re: Division formula issue

Yes, and the output is still 0

Re: Division formula issue

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

QlikView ‒ Div - script and chart function

MVP
MVP

Re: Division formula issue

could you post your .qvw?

Re: Division formula issue

See if the Num function helps:

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

Not applicable

Re: Division formula issue

Thank you, this worked perfectly!

Re: Division formula issue

Awesome , glad it did