Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
pgalvezt
Valued Contributor

Divide By Total

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

3 Replies
Partner
Partner

Re: Divide By Total

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
Valued Contributor

Re: Divide By Total

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

Highlighted
pgalvezt
Valued Contributor

Re: Divide By Total

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