topic Re: divide by expression in QlikView

divide by expression

Wed, 13 Feb 2013 15:03:00 GMT

Hi guys,

I want to divide som values but I cant find the correct expression .

I have a table witch some coloms

sum(a)

4471

sum(b)

5572

sum(c)

925

I want to make an expression

sum(a)/(sum(b)-sum(c))

4471/(5572-925) =0,926

but i Qlikview outcome 0,73

Thanks in advance

dmohanty — Wed, 13 Feb 2013 15:10:26 GMT

Hi,

Use this:

=Div (sum(a), (sum(b) - sum(c)))

manideep78 — Wed, 13 Feb 2013 15:29:29 GMT

LET vDiff= Sum(b)-Sum(c);

then do this,

sum(a)/$(vDiff)

hope it helps

Thu, 14 Feb 2013 09:26:57 GMT

Thank you!

Thu, 14 Feb 2013 09:27:17 GMT

Thank you! It works

er_mohit — Thu, 14 Feb 2013 09:44:47 GMT

your expression is absolutely write i don't know why it didn't give you correct answer..

sum(a)/(Sum(b)-Sum(c))

see the attached file