By Selecting a month..I need the chart to be static (Avoid using Alternate State)

[bharani8]

Hi Experts - In the attached qvw file, when i click on the month, i dont want the chart to change (It should be static).. Plz Help..

stalwar1‌ loveisfail‌

PLZ AVOID USING ALTERNATE STATE & DETACH methods

Let me know other than the above mentioned methods, anything else is possible or not ?

[jonathandienst]

Do you mean you want the chart to respond to month selection, but not other selections?

[bharani8]

Chart should not change .. Should be static irrespective of any selection made in the "Month Name"

PLZ AVOID USING ALTERNATE STATE & DETACH methods

[tresesco · Accepted solution]

In your calculated dimension in the chart, wherever you used aggregation functions (here max()) include the set analysis part as well. PFA

Also, request to close the threads you post Re: Aggr function can be used in Script ? marking correct/helpful replies.

[bharani8]

Super!!! Was scratching my head for 2 days.. Thanks a Lot!! One more quick clarrification....

In the "Select Month" Field.. Once we select a month... Again if we click on that dropdown...  Behaviour is bit different...

Example.. After selecting a month... if i want to select one more month .. it is not possible... Any solution to this??

[tresesco]

Try putting '{1}' or the same set analysis section in all max() functions in the expression you used in multibox expression.

[bharani8]

Perfectly Worked!! TY!!!!!!

[bharani8]

Just curious to know why the behavior is like that?

[tresesco]

I like that you 'Like'(d) my reply. However, I feel since you are the OP, a 'helpful' tag is more appropriate here, because that (probably) was helpful to you. 'Like' would be more relevant to the non-OP people.

[tresesco]

I am bad at explaining (especially when it comes to non-verbal communication). You have to learn more about Set Analysis and perhaps Aggr() as well to understand such behavior. Lot of documents/discussions would be available on these topics here in this community. Try to refer those.

As a quick answer, - it is because when you select something from the list which is calculated using aggr(), rest of the possible values actually go out-of-scope, so you don't see them in the drop-down.