Show Month

[pgalvezt]

Hi, I trying to show the variation month

Periodo	Condición
Enero - 2011	Fecha_Pro = '30/11/2010' or '31/12/2010' or '31/01/2011'
Febrero - 2011	Fecha_Pro = '31/12/2010' or '31/01/2011' or '28/02/2011'

And So on.

When I select Ene 2011 Fecha_Pro Show me  '30/11/2010' or '31/12/2010' or '31/01/2011' But What I want is when I select February QV show me  '31/12/2010' or '31/01/2011' or '28/02/2011'. So  '30/11/2010'  Dissapear and '28/02/2011' Appears. I Put a sample for better Comprehenssion

Thank you!

[MayilVahanan]

HI

From your qv file, i notified one thing, you are loading date separately, but there is no link between two tables. and also there is no field in it also. so please check before post there is field in file or not?

And also not understand why you load like this

LOAD

     Date(Fecha_Pro) as Fecha_Pro

FROM

[..\QVD\B.qvd]

(qvd)

Where Fecha_Pro = '30/11/2010' Or Fecha_Pro = '31/12/2010' Or Fecha_Pro = '31/01/2011';

for this, you can load like this

LOAD

     Año,

     Mes,

      if(match(Date(Fecha_Pro), '30/11/2010' , '31/12/2010', '31/01/2011'),Date(Fecha_Pro)) as Fecha_Pro,

     Periodo

FROM

[..\QVD\B.qvd]

(qvd);

edit:

=sum({<MonthName = {'$(=MonthName(AddMonths(max(Fecha_Protesto),-2)))'}>}Field)

=sum({<MonthName = {'$(=MonthName(AddMonths(max(Fecha_Protesto),-1)))'}>}Field)

=sum({<MonthName = {'$(=MonthName(AddMonths(max(Fecha_Protesto),0)))'}>}Field)

But I did clic in Period (Febreaury) QV doesn't show data?

for this

here MonthName is filter (like jun 2012) . do you have MonthName as filter in your script?

sum({<MonthName = {'$(=MonthName(AddMonths(max(Fecha_Protesto),-2)))'}>}Field)

[pgalvezt]

Hi,

Sorry I sent you the wrong file.

[pgalvezt]

For Better Comprehenssion I need to do this:

Periodo	Condición 2
Enero - 2011	Fechas de protesto = '30/11/2010' or '31/12/2010' or '31/01/2011'
Febrero - 2011	Fechas de protesto = '31/12/2010' or '31/01/2011' or '28/02/2011'
Marzo - 2011	Fechas de protesto = '31/01/2011' or '28/02/2011' or '31/03/2011'
Abril - 2011	Fechas de protesto = '28/02/2011' or '31/03/2011' or '30/04/2011'
Mayo - 2011	Fechas de protesto = '31/03/2011' or '30/04/2011' or '31/05/2011'
Junio - 2011	Fechas de protesto = '30/04/2011' or '31/05/2011' or '30/06/2011'
Julio - 2011	Fechas de protesto = '31/05/2011' or '30/06/2011' or '31/07/2011'

[MayilVahanan]

HI

Try like this

Please find the attached file...

[pgalvezt]

The expressions are very good. But you have in your Script (Generate) I have a Table with Period (Ene 2011 Until Sept 2012) How Can I Get the same result?

Thanks!

[MayilVahanan]

Hi

Both are same.. instead of autogenerate you can use your table. but expression will help. If not means, please post a sample file with that  chart ..please don't post empty file..

[pgalvezt]

Ok Now Works but Just when I select manually the period within the 3 monthnames. How can I get the 3 Monthnames with just 1 clic over ene 2011?

I Attached the image for better comprenhension.

Thank you!

[MayilVahanan]

HI

Use Perdio instead of monthname in expression..

[pgalvezt]

I Tried:

sum({<Periodo = {'$(=Periodo(AddMonths(max(Fecha_Protesto),-2)))'}>}DeudaK)

sum({<Periodo = {'$(=Periodo(AddMonths(max(Fecha_Protesto),-1)))'}>}DeudaK)

sum({<Periodo = {'$(=Periodo(AddMonths(max(Fecha_Protesto),0)))'}>}DeudaK)

Appear No data to show.

[MayilVahanan]

Hi

sum( {< periodo = {'$( = monthname(addmonths(max(fecho_persto),0)))'}>}deudak)

TRY LIKE ABOVE..

MONTHNAME is a default function...

Perido is field...

Now u understand?? Why not o/p not come nu