Help Set Analisys IF

[pgalvezt]

Hello,

I have an expression that works like that:

Sum({<Fecha_Protesto2={'30-11-2010','31-12-2010','31-01-2011'}>}DeudaK) + If(TDCORTE2='31-01-2011', Sum(If(Cod_Bloqueo <> 8, Deuda_Total))) (Works Fine)

Separately works fine. The problem is when I trie to join them (Using 'Or' But doesn't work) The idea is QlikView do the filters as Follows:

Sum({<Fecha_Protesto2={'30-11-2010','31-12-2010','31-01-2011'}>}DeudaK) + If(TDCORTE2='31-01-2011', Sum(If(Cod_Bloqueo <> 8, Deuda_Total))) Or  //Enero2011

Sum({<Fecha_Protesto2={'31-12-2010','31-01-2011','28-02-2011'}>}DeudaK) + If(TDCORTE2='28-02-2011', Sum(If(Cod_Bloqueo <> 8, Deuda_Total))) Or  //Febrero 2011

Sum({<Fecha_Protesto2={'31-01-2011','28-02-2011','31-03-2011'}>}DeudaK) + If(TDCORTE2='31-03-2011', Sum(If(Cod_Bloqueo <> 8, Deuda_Total)))//Marzo 2011

Thank you!

[whiteline · Accepted solution]

Oh, I see... sorry, friday

=If(TDCORTE2='31-01-2011', Sum(If(Cod_Bloqueo <> 8, Deuda_Total))+Sum({<Fecha_Protesto2={'30-11-2010','31-12-2010','31-01-2011'}>}DeudaK),

If(TDCORTE2='28-02-2011', Sum(If(Cod_Bloqueo <> 8, Deuda_Total))+Sum({<Fecha_Protesto2={'31-12-2010','31-01-2011','28-02-2011'}>}DeudaK),

If(TDCORTE2='31-03-2011', Sum(If(Cod_Bloqueo <> 8, Deuda_Total))+Sum({<Fecha_Protesto2={'31-01-2011','28-02-2011','31-03-2011'}>}DeudaK))))

[Clever_Anjos]

Could you post a little sample of your data?

[pgalvezt]

Hahaha yes finally is friday many thanks for your answer.

[Clever_Anjos]

SUM({<Cod_Bloqueo={"*"}-{"8"},Fecha_Protesto2={">=$(=AddMonths(TDCORTE2,-3))"}*{"<=$(=TDCORTE2)"}>}DeudaK)