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!

[pgalvezt]

Any Help?

Thanks!

[pgalvezt]

Anyone?

Thanks!

[MayilVahanan]

HI

Are you expecting like that attached file?

32 MB is bigger file to download and see it

Hope it helps

Regards,

R.Mayil Vahanan

[richardcripps]

Hi

If I've misunderstood this then I apologise.

But it would seem that your two tables are linked by some kind of order id (homologo), the two fields that you want to use are on two different tables and are joined together by homologo and so are related to eachother that way.

So Febero in your table tartjetas isn't related to Fecha_Protesto of 28/02/2011 in the other table as the join happens on homologo.

Would the best thing to do is when loading in the data for the table Bsc01 would be to add a field that calculated the month of the Fecha_Protesto. e.g. Month(Fecha_Protesto)

This function could be different in the language you are using.

[pgalvezt]

Yes. Exactly I need the same result like R.Mayil put in his discussion but the cut date is going to be until July. After July Doesn't run this logic. Is just Until July. How can I avoid this.

Thanks!

[pgalvezt]

Im Sorry R.Mayil I put a QlikView light. Plus What I want to achieve.

Thanks

[MayilVahanan]

HI

Are you want untill july? after that no need to display ?

if so,

try ike this

=if(not WildMatch(MonthName,'Jul*','Aug*','Sep*','Oct*','Nov*','Dec*'), sum({<MonthName = {'$(=MonthName(AddMonths(max(Date),-2)))'}>}Sales))

or

=if(MonthNum < 7, sum({<MonthName = {'$(=MonthName(AddMonths(max(Date),-2)))'}>}Sales))

where monthnum is Month(Date)*1 in script

edit:

Can't able to see any fields in it. not able to reload because i don't have qvd for it..

[pgalvezt]

I Attached A Qv File Lighter.

[pgalvezt]

I Tried this:

=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.

Thanks!