topic Re: Show Month in QlikView

Show Month

pgalvezt — Wed, 31 Oct 2012 14:52:07 GMT

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!

Re: Show Month

pgalvezt — Wed, 31 Oct 2012 15:24:26 GMT

Any Help?

Thanks!

Re: Show Month

pgalvezt — Wed, 31 Oct 2012 17:04:04 GMT

Anyone?

Thanks!

Re: Show Month

MayilVahanan — Wed, 31 Oct 2012 17:32:24 GMT

Are you expecting like that attached file?

32 MB is bigger file to download and see it

Hope it helps

Regards,

R.Mayil Vahanan

Re: Show Month

richardcripps — Wed, 31 Oct 2012 17:41:17 GMT

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.

Re: Show Month

pgalvezt — Wed, 31 Oct 2012 17:46:09 GMT

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!

Re: Show Month

pgalvezt — Wed, 31 Oct 2012 17:53:12 GMT

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

Thanks

Re: Show Month

MayilVahanan — Wed, 31 Oct 2012 17:56:08 GMT

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

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

Re: Show Month

pgalvezt — Wed, 31 Oct 2012 18:46:25 GMT

I Attached A Qv File Lighter.

Re: Show Month

pgalvezt — Wed, 31 Oct 2012 18:48:29 GMT

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!

Re: Show Month

MayilVahanan — Wed, 31 Oct 2012 18:54:19 GMT

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)

Re: Show Month

pgalvezt — Wed, 31 Oct 2012 19:08:19 GMT

Hi,

Sorry I sent you the wrong file.

Re: Show Month

pgalvezt — Wed, 31 Oct 2012 19:16:03 GMT

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'

Re: Show Month

MayilVahanan — Wed, 31 Oct 2012 19:35:48 GMT

Try like this

Please find the attached file...

Re: Show Month

pgalvezt — Wed, 31 Oct 2012 20:08:46 GMT

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!

Re: Show Month

MayilVahanan — Wed, 31 Oct 2012 20:13:54 GMT

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

Re: Show Month

pgalvezt — Wed, 31 Oct 2012 21:08:03 GMT

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!

Re: Show Month

MayilVahanan — Wed, 31 Oct 2012 21:12:48 GMT

Use Perdio instead of monthname in expression..

Re: Show Month

pgalvezt — Wed, 31 Oct 2012 21:22:48 GMT

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.

Re: Show Month

MayilVahanan — Wed, 31 Oct 2012 22:24:48 GMT

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