topic Re: Set Analysis problem in QlikView

Set Analysis problem

pgalvezt — Fri, 28 Sep 2012 20:46:13 GMT

hello, anybody can help to get the real result:

(This Work pefectly)

=(Sum(If(Cod_Bloqueo <> 8, Deuda_Total))/Divisor) - (Sum(Saldo_Cob)/Divisor) - (Sum(Saldo_Dic)/Divisor) -(Sum(Saldo_Susp)/Divisor)

But I need the same formula here:

(Doesn't work)

(Sum({<Tramos={'Tramo 0'}>}If(Cod_Bloqueo <> 8, (Deuda_Total))/Divisor) - (Sum(Saldo_Cob)/Divisor) - (Sum(Saldo_Dic)/Divisor) -(Sum(Saldo_Susp)/Divisor)

Thank you.

Re: Set Analysis problem

MayilVahanan — Fri, 28 Sep 2012 21:01:00 GMT

Did you check 'Tramo 0' is in Tramos? or for that particular field, there may be no data.. So please refer the data once.

Re: Set Analysis problem

pgalvezt — Mon, 01 Oct 2012 12:30:03 GMT

Hi, Sorry for the delay. I checked tramo 0 with this formula and works perfect.

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

I need to add the follow:

- (Sum(Saldo_Cob)/Divisor) - (Sum(Saldo_Dic)/Divisor) -(Sum(Saldo_Susp)/Divisor)

Thanks

Re: Set Analysis problem

pgalvezt — Mon, 01 Oct 2012 13:54:08 GMT

Any Help?

Thanks!

Re: Set Analysis problem

pgalvezt — Mon, 01 Oct 2012 15:27:00 GMT

Anyone can help me with this?

Thank you!

Re: Set Analysis problem

Mon, 01 Oct 2012 16:45:01 GMT

Try:

If(Cod_Bloqueo <> 8 and Tramos='Tramo 0', (Deuda_Total))/Divisor) - (Sum(Saldo_Cob)/Divisor) - (Sum(Saldo_Dic)/Divisor) -(Sum(Saldo_Susp)/Divisor)

Re: Set Analysis problem

Mon, 01 Oct 2012 16:46:07 GMT

Whoops, one to many parentheses. Try:

If(Cod_Bloqueo <> 8 and Tramos='Tramo 0', (Deuda_Total/Divisor) - (Sum(Saldo_Cob)/Divisor) - (Sum(Saldo_Dic)/Divisor) -(Sum(Saldo_Susp)/Divisor)

Re: Set Analysis problem

pgalvezt — Mon, 01 Oct 2012 17:11:33 GMT

Many Thank to you Rebeccad You gave me a good Idea and now I could solve the problem:

=((Sum(If(Cod_Bloqueo <> 8 And Tramos = 'Tramo 0', Deuda_Total))/Divisor) - (Sum(Saldo_Cob)/Divisor) - (Sum(Saldo_Dic)/Divisor) -(Sum(Saldo_Susp)/Divisor))

((Sum(If(Cod_Bloqueo <> 8, Deuda_Total))/Divisor) - (Sum(Saldo_Cob)/Divisor) - (Sum(Saldo_Dic)/Divisor) -(Sum(Saldo_Susp)/Divisor))