Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi,
Put this in the dimension:
= YearField & aggr(max(MonthField), YearField)
Regards,
Jonathan
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
there you go:
Enjoy,
Jonathan
Don’t work, but thanks for your effort
May be you can help me with the real case.
Thanks!
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
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
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)
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