topic Re: Set Analysis problem within Line Graph, doesn't ignore selections?!? in QlikView

Set Analysis problem within Line Graph, doesn't ignore selections?!?

marcus_steggall — Thu, 23 Apr 2015 17:42:40 GMT

Evening everyone, hope you're well.

Quick one I hope, still being relatively new to qlikview developing.

I've created a set analysis, basically showing the sum of hours... over the last 12 months (This is shown at the bottom of my attached file).

I then put this code into a line graph and as you can see, this nicely shows the figures per month for that time range.

However, if i was to click on one of the "Period_Number"... the line graph changes upon that selection.

Even though i've put some code into the line graph, saying ignore "Period_Number" selection.

Any ideas, where i'm being silly here?

Time is much appreciated.

Re: Set Analysis problem within Line Graph, doesn't ignore selections?!?

sunny_talwar — Thu, 23 Apr 2015 17:57:52 GMT

The issue is that somehow you won't be able to control the dimension from reducing after selection. You can use the alternate state concept in this case. Give it a try and see if this solves your purpose.

Best,

Sunny

Re: Set Analysis problem within Line Graph, doesn't ignore selections?!?

sunny_talwar — Thu, 23 Apr 2015 18:06:45 GMT

Use this as your expression:

=Sum({Practice<[Period_Sort]={">=$(=max({$}[Period_Sort]-1)-11)<=$(=max({$}[Period_Sort])-1)"}>} Hours)

and this as your sort order:

=Avg({Practice}Period_Sort)

HTH

Best,

Sunny

Re: Set Analysis problem within Line Graph, doesn't ignore selections?!?

marcus_steggall — Fri, 24 Apr 2015 08:45:10 GMT

Hi Sunny,

The expression you sent me, works an absolute treat in that example... can i ask what is meant by the "Practice" piece within the code?

Re: Set Analysis problem within Line Graph, doesn't ignore selections?!?

sunny_talwar — Fri, 24 Apr 2015 10:12:33 GMT

Practice is one of the alternate state which you had already created in your application. I just made use of it.

Best,

Sunny

Re: Set Analysis problem within Line Graph, doesn't ignore selections?!?

marcus_steggall — Fri, 24 Apr 2015 11:25:11 GMT

ahhh yes of course Adding alternate states to the actual expression.

Appreciate your help again, most helpful.