This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
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!
See if the Num function helps:
View solution in original post
May be try one of these:
did you try?
sum(A) / sum(B)
Yes, and the output is still 0
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
could you post your .qvw?
Thank you, this worked perfectly!
Awesome , glad it did