ratio with 2 expressions - Qlik Community

Report Inappropriate Content · ‎2012-07-20

Hello,

i have to do ratio/percentage to make a line on my combo-chart, like:

Div(Sum(X), Sum(Y))*100

but it doesn't work ...

Tks for your help

Report Inappropriate Content · ‎2012-07-20

round(Sum(X)/Sum(Y))*100

or

floor(Sum(X)/Sum(Y))*100

swuehl · ‎2012-07-20

div() is integer division (i.e. returns the integer part only), so your expression probably results in all zero?

Just use

=sum(X) / sum(Y)

and format as percentage in numbers tab.

Report Inappropriate Content · ‎2012-07-20

Doesn't work...

😞

swuehl · ‎2012-07-20

Would be good if you tell us a bit more what you have, get and expect.

Are X and Y fields? Do sum(X) and sum(Y) return values in the same context you use sum(X) / sum(Y)? What are these results?

Report Inappropriate Content · ‎2012-07-20

Post your qlik

CELAMBARASAN · ‎2012-07-20

Hi,

Just check whether Sum(Y) results zero then it doesn't produce value for that Sum(X).

Simply a divide by zero error.did you chk that?

Report Inappropriate Content · ‎2012-07-24

it's ok.

I done sum(x)/sum(Y) with all my selection in(X) and all my selection in (Y) but it's not very convenient....