Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
pgalvezt
Specialist
Specialist

Set Analysis problem

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.

1 Solution

Accepted Solutions
pgalvezt
Specialist
Specialist
Author

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

View solution in original post

7 Replies
MayilVahanan

Hi

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

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
pgalvezt
Specialist
Specialist
Author

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

pgalvezt
Specialist
Specialist
Author

Any Help?

Thanks!

pgalvezt
Specialist
Specialist
Author

Anyone can help me with this?

Thank you!

Not applicable

Try:

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

Not applicable

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)

pgalvezt
Specialist
Specialist
Author

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