topic Re: Divide By Total in QlikView

Divide By Total

pgalvezt — Mon, 20 Aug 2012 21:57:33 GMT

Hi, Independent the formulas works fine

Sum

({<Tramos={'Tramo 0'}>}If(Cod_Bloqueo <> 8, Deuda_Total))/(Sum(TOTAL{<Tramos>}If(Cod_Bloqueo <> 8, Deuda_Total

)))

But Gave me 1.

The first result gives 17000000

The total Gives 31000000000000.

But is not calculating the real.

Thanks

erichshiino — Mon, 20 Aug 2012 22:28:15 GMT

Hi,

Which dimensions do you have in your chart?

Maybe you'd like to use

Sum(TOTAL{Tramos}If(Cod_Bloqueo <> 8,Deuda_Total

)

as your second expression or

Sum(TOTAL{<Tramos = >}If(Cod_Bloqueo <> 8,Deuda_Total

)

You can also remove the if condition and use it as a set analysis:

Sum

({<Tramos={'Tramo 0'}, Cod_Bloqueo-={8}>} Deuda_Total)

and

Sum

({<Tramos={'Tramo 0'}, Cod_Bloqueo-={8}>} total Deuda_Total)

Hope it helps,

Erich

pgalvezt — Tue, 21 Aug 2012 13:54:47 GMT

Hi, Thank you for your reply but still gives 1. It's as if I were dividing system 370000/370000.

Operates separately formulas. A formula giving the leg and the other gives me the total but when I get one split.

Thanks

pgalvezt — Tue, 21 Aug 2012 14:07:03 GMT

Sorry I found the problem my formula was fine. It was a format numeric problem now works.