ratio with 2 expressions

[#1]

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

[#2]

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

or

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

[swuehl]

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.

[#4]

Doesn't work...

😞

[swuehl]

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?

[#6]

Post your qlik

[CELAMBARASAN]

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?

[#8]

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....