Exclude selectjions in chart

[Anonymous]

Hi All,

I have list box with all month value .Jan to Dec.

I have another object  apha period in chart as dimension which  contains combination of year and month 2015.01

my requiremnt is if i select Month list box it is corresponding corresponding alpha period value

for suppose if i select jan it is showing 201501

But i want to display all the alphaperiod value even if i select jan month .

[sunny_talwar]

Are we talking about doing this in a list box? May be use an alternate state which doesn't impact any selection on the inherited state. or you can give this a try as well for your list box expression:

=Aggr(Only({<month = >}alphaperiod), alphaperiod)

[Anonymous]

Hi

I have tried your expression but not working

Alphaperiod is used as dimension in chart

[simenkg]

In your expression, add

[Month]= to the Set analysis part.

If you dont have a set analysis in the expression then the whole expression will become something like:

sum({<[Month]=>} Value)

Remember that field names are case sensitive

[sunny_talwar]

Use this in your expressions:

{<month = >}

This will tell your expression (and dimension) that it should not change with selection in month listbox

[Anonymous]

Hi

below is my set expr

i have added my monthname in the set epression but it is not working

=sum({<ANALYTICAL_CATEGORY={'PROFITLOSS'},PERIOD_YEAR=,PERIOD_ALPHA ={'<=$(vMaxPeriodAlpha)'},MONTHNAME=,MONTH_NAME=>}BUDGET)/FactorValue

[Anonymous]

HI all,

I have added the below expression it is working

Sum({<MONTHNAME=>}1)

But if i made similar changes in the my set expression it is not getting exact result

MOdified set expression

=sum({<ANALYTICAL_CATEGORY={'PROFITLOSS'},PERIOD_YEAR=,PERIOD_ALPHA ={'<=$(vMaxPeriodAlpha)'},MONTHNAME=,MONTH_NAME=>}BUDGET)/FactorValue

[jonathandienst]

How is vMaxPeriodAlpha defined? If you create a text object with =vMaxPeriodAlpha as the expression, do you get what you would expect?

As always, the best way to get accurate suggestions is for you to post a sample the shows the issue, together with what you expect as the results.

[Anonymous]

HI i have figured out problem Thanks for your responses