topic Re: By Selecting a month..I need the chart to be static (Avoid using Alternate State) in QlikView

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

bharani8 — Wed, 25 Nov 2020 16:16:04 GMT

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 ?

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

jonathandienst — Thu, 02 Nov 2017 05:49:51 GMT

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

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

bharani8 — Thu, 02 Nov 2017 05:54:43 GMT

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

PLZ AVOID USING ALTERNATE STATE & DETACH methods

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

tresB — Thu, 02 Nov 2017 05:57:28 GMT

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.

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

bharani8 — Thu, 02 Nov 2017 06:03:31 GMT

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

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

tresB — Thu, 02 Nov 2017 06:14:08 GMT

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

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

bharani8 — Thu, 02 Nov 2017 06:19:29 GMT

Perfectly Worked!! TY!!!!!!

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

bharani8 — Thu, 02 Nov 2017 06:19:59 GMT

Just curious to know why the behavior is like that?

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

tresB — Thu, 02 Nov 2017 06:25:22 GMT

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.

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

tresB — Thu, 02 Nov 2017 06:34:22 GMT

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.