topic Select diffrent maximun months for different years in QlikView

Select diffrent maximun months for different years

Thu, 07 Jul 2011 16:54:49 GMT

Hi, I’ve a Pivot Table with two dimensions, years and months

I need do the following: when I select the year dimension, not to summarize the months. Instead, I need get the maximum month per year.

The problem is that i don't have the same periods for each year

Ex:

2010

1,2,3,4,5,6,7,8,9,10,11,12

2011

1,2,3,4,5,6

When i select Years dimension, max(months) returns me 12 and I need 2010/12 & 2011/6 selected, is it possible?

I'm stopped here, I has been tryin with AGGR() and Set Analysis groups but i can't get the solution.

Thanks a lot.

Re: Select diffrent maximun months for different years

Thu, 07 Jul 2011 17:23:40 GMT

Hi,

Put this in the dimension:

= YearField & aggr(max(MonthField), YearField)

Regards,

Jonathan

Select diffrent maximun months for different years

Thu, 07 Jul 2011 18:37:24 GMT

Thanks Jonathan it´s a great approach. it's work good, now I've the maximun month per each year

But now I really need Expand and Collapse the years.

Expanded: Show for each years all diffrent months

Collapsed: Show only the maximum month for each year

Understand me?

Thanks again for your kindness and quickly

Re: Select diffrent maximun months for different years

Thu, 07 Jul 2011 19:11:44 GMT

there you go:

Enjoy,

Jonathan

Re: Select diffrent maximun months for different years

Thu, 07 Jul 2011 19:44:44 GMT

Don’t work, but thanks for your effort

May be you can help me with the real case.

Thanks!

De: jonathandd

Enviado el: jueves, 07 de julio de 2011 04:12 p.m.

Para: Campos, Esteban

Asunto: - Re: Select diffrent maximun months for different years

QlikCommunity<http://community.qlik.com/index.jspa>

Re: Select diffrent maximun months for different years

created by jonathandd<http://community.qlik.com/people/jonathandd> in New to QlikView - View the full discussion<http://community.qlik.com/message/131119#131119

Re: Select diffrent maximun months for different years

Fri, 08 Jul 2011 06:15:55 GMT

Dear Esteban,

I have no clue what you mean. When I look to your application it seems to do it, no?

Sorry I miss you point. Explain what you expect if you need more.

Regards,

Jonathan

Re: Select diffrent maximun months for different years

Fri, 08 Jul 2011 12:58:29 GMT

Sorry if I'm not clear, I show you what I need to do

Expanded: (Remember the column values for 2011/5 & 2010/12)

Collapsed: At this moment It’s Summarize all periods values (This is wrong for a Balance Sheet) I Need this view for Collapsed state (It’s a Copy & Paste Image)

De: jonathandd

Enviado el: viernes, 08 de julio de 2011 03:16 a.m.

Para: Campos, Esteban

Asunto: - Re: Select diffrent maximun months for different years

QlikCommunity<http://community.qlik.com/index.jspa>

Re: Select diffrent maximun months for different years

created by jonathandd<http://community.qlik.com/people/jonathandd> in New to QlikView - View the full discussion<http://community.qlik.com/message/131231#131231