topic Re: Help Set Analisys IF in QlikView

Help Set Analisys IF

pgalvezt — Fri, 16 Nov 2012 13:50:41 GMT

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!

Re: Help Set Analisys IF

pgalvezt — Fri, 16 Nov 2012 17:01:57 GMT

Any Help?

Thanks!

Re: Help Set Analisys IF

Clever_Anjos — Fri, 16 Nov 2012 17:12:22 GMT

You shouldn´t use "OR" but the normal IF function syntax

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

If(TDCORTE2='28-02-2011', Sum(If(Cod_Bloqueo <> 8, Deuda_Total)),

If(TDCORTE2='31-03-2011', Sum(If(Cod_Bloqueo <> 8, Deuda_Total)))

Re: Help Set Analisys IF

pgalvezt — Fri, 16 Nov 2012 17:53:34 GMT

Thank you Clever for your reply. But what happens with:

Sum({<Fecha_Protesto2={'31-12-2010','31-01-2011','28-02-2011'}>}DeudaK) Is a different date.

I have to join Enero, Febreo,Marzo And So On.

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

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

//Sum({<Fecha_Protesto2={'31-03-2011','30-04-2011','31-05-2011'}>}DeudaK) + If(TDCORTE2='31-05-2011', Sum(If(Cod_Bloqueo <> 8, Deuda_Total)))//Mayo 2011

//Sum({<Fecha_Protesto2={'30-04-2011','31-05-2011','30-06-2011'}>}DeudaK) + If(TDCORTE2='30-06-2011', Sum(If(Cod_Bloqueo <> 8, Deuda_Total)))//Junio 2011

//Sum({<Fecha_Protesto2={'31-05-2011','30-06-2011','31-07-2011'}>}DeudaK) + If(TDCORTE2='31-07-2011', Sum(If(Cod_Bloqueo <> 8, Deuda_Total)))//Julio 2011

Re: Help Set Analisys IF

Clever_Anjos — Fri, 16 Nov 2012 18:01:14 GMT

Do you want the sum of all "Fecha_Protesto2" or depending of TDCORTE2?

Re: Help Set Analisys IF

pgalvezt — Fri, 16 Nov 2012 18:06:07 GMT

I need to show

Enero

Febrero

And So on Depending Of Fecha_Protesto and TDCORTE2

I left a sample picture for better comprehension.

Thank you

Re: Help Set Analisys IF

whiteline — Fri, 16 Nov 2012 18:11:58 GMT

Hi.

I think you should describe what do you want to calculate.

Since in your expressions the result is the same...

Did you mean:

Sum({<Fecha_Protesto2={'30-11-2010','31-12-2010','31-01-2011'}>}DeudaK)

If(TDCORTE2='31-01-2011' or TDCORTE2='28-02-2011' or TDCORTE2='31-03-2011', Sum(If(Cod_Bloqueo <> 8, Deuda_Total)))

Re: Help Set Analisys IF

pgalvezt — Fri, 16 Nov 2012 18:18:01 GMT

Careful Sum({<Fecha_Protesto2={'30-11-2010','31-12-2010','31-01-2011'}>}DeudaK) Its moving one month. Is not always '30-11-2010','31-12-2010','31-01-2011'.

Is:

'30-11-2010','31-12-2010','31-01-2011'.

'31-12-2010','31-01-2011','28-02-2011'

'31-01-2011','28-02-2011','31-03-2011' Its moving one month.

I need to show the other months (Thats all) For now I just show Ene (Jan)

Thanks.

Re: Help Set Analisys IF

Clever_Anjos — Fri, 16 Nov 2012 18:23:58 GMT

Well,

If I understood well you want to sum 3 months relatives to Fecha_Protesto.

Did I get your idea?

Re: Help Set Analisys IF

pgalvezt — Fri, 16 Nov 2012 18:26:12 GMT

Yes I did and show the totals for months. Look at the picture I would like to show Ene, Feb and so on With their totals.

Re: Help Set Analisys IF

whiteline — Fri, 16 Nov 2012 18:27:01 GMT

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

Re: Help Set Analisys IF

Clever_Anjos — Fri, 16 Nov 2012 18:28:47 GMT

Could you post a little sample of your data?

Re: Help Set Analisys IF

pgalvezt — Fri, 16 Nov 2012 18:32:47 GMT

Hahaha yes finally is friday many thanks for your answer.

Re: Help Set Analisys IF

Clever_Anjos — Fri, 16 Nov 2012 18:40:02 GMT

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