topic Re: Graph Selections in QlikView

Graph Selections

Anonymous — Tue, 17 Feb 2015 19:52:07 GMT

Is it possible to lock a graph from year selections being made? I know I can get rid of the list box selection, but is it possible to lock down a graphy from a yearly selection? The user wants the graph to remain static for all 3 years, and allow other non year selections to be made. Here is the graph:

Thank you,

Justin

Re: Graph Selections

sunny_talwar — Tue, 17 Feb 2015 19:56:08 GMT

Use {<Year = {'*'}>} as your set modifier within your expression. This will make sure that all years display regardless of the selection.

Best,

Re: Graph Selections

Anonymous — Tue, 17 Feb 2015 20:01:17 GMT

Sunindia,

Thank you for the help that will keep all the selections on the chart. That will however move the selections around if the user selects a different year, and also changes the color to all one year. Is there a way to lock everything down? I have inclosed two pictures:

Justin

Re: Graph Selections

sunny_talwar — Tue, 17 Feb 2015 20:05:13 GMT

Locking everything down could be done using this {1}, but I thought you said that you want the user to be able to make non-year related selections.

To understand what happened, when you made a selection on the year all the three bars changed to show the same color?

Best,

Re: Graph Selections

maxgro — Tue, 17 Feb 2015 20:06:00 GMT

ignore some selections

Ignore all selections except some specific fields using Set Analysis

or maybe with set analysis

sum( {1} Sales )
returns total sales within the application, disregarding the selection but not the dimension. If used in a chart with e.g. Products as dimension, each product will get a different value.

Re: Graph Selections

Anonymous — Tue, 17 Feb 2015 20:10:01 GMT

Sunindia,

That is correct, I want to allow them to select different products or different months, but I do not want the Year to be a selection. When Year is selected, the charts all turn the same color like in the bottom picture I included. I also tried set analysis with Year = , but that changed to the same color Year as well.

Re: Graph Selections

sunny_talwar — Tue, 17 Feb 2015 20:14:00 GMT

Are you using one expression and Year as your dimension or are you using three expressions??

Best,

Re: Graph Selections

Anonymous — Tue, 17 Feb 2015 20:17:59 GMT

I am using one expression for all 3 years. I was trying to avoid having to use 3 expressions if possible since I have replicated this similar graph about 8 times. Do you think that will fix the problem?

Thanks,

Justin

Re: Graph Selections

sunny_talwar — Tue, 17 Feb 2015 20:21:51 GMT

No I think what you are doing is correct. One question that comes to my mind is: Are you using some kind of if statement for the Background Color? Cause that is the only way you can color the bars in different colors when they all originate from the same the expression.

Let me if you are using a statement there and it would be great if you can post what you are doing.

Best,

Re: Graph Selections

Anonymous — Tue, 17 Feb 2015 20:22:47 GMT

Massimo,

I tried using the expression suggested but I received a syntax error. Here is the expression I tried:

sum({$<[$(=Concat({1<$Field-={'YEAR'}>}distinct $Field,']=,[')&']=')>} Amount)

Any suggestions for how I can alter the statement to work correctly? I have a couple of other fields in the set analysis as well, and I just put a comman after ]=')

Thanks,

Justin

Re: Graph Selections

Anonymous — Tue, 17 Feb 2015 20:26:08 GMT

I am using a variable as follows:

if(not IsNull(R), RGB(R, G, B)) which ties to an inline statement I created.

Thank you,

Justin

Re: Graph Selections

sunny_talwar — Tue, 17 Feb 2015 20:31:30 GMT

You will need to share your Inline table as well as the variable. Is this inline table connected to the Year field somehow? Do you see activity in the values of R, G, B when you make a selection in the year field? Cause that is the only thing that could explain the changing colors.

HTH

Best,

Re: Graph Selections

Anonymous — Tue, 17 Feb 2015 20:38:23 GMT

Here is both the inline table and variable:

LOAD * INLINE [

YEAR, YEARSORT, R, G, B

2014, 1, 0, 106, 182

PLAN, 2, 169, 209, 92

2013, 3, 111, 175, 215

];

Variable is vColor =

if(not IsNull(R), RGB(R, G, B))

I have the background color of the graph set to $(vColor). When selections are made, without the year being locked down, the colors come back correctly. 2014 is a dark blue, plan a light green, and 2013 is a light blue.

Thanks again,

Justin

Re: Graph Selections

sunny_talwar — Tue, 17 Feb 2015 21:04:03 GMT

This is a workaround, but it solves your purpose. You can create another state and the list box for Year would be in a alternate state. Any selection made in the alternate state won't impact anything in your default state.

Note: But wherever you would want to use the expression which changes with the Year, you will have to make sure that it is associated with Alternate state's Year.

Second workaround is to create three expressions and no dimensions.

I am attaching a qvw in which I have tried to implement both methods for you. Please have a look and let me know what you think.

Best,

Re: Graph Selections

Anonymous — Tue, 17 Feb 2015 21:39:03 GMT

Perfect,

Thank you for the help. Although it will take longer, I believe setting up three expressions will work better as it is more simplistic. Are their any benefits to using alternate states? Seems like there would be more work on the back end outside of the charts.

Thanks,

Justin

Re: Graph Selections

sunny_talwar — Tue, 17 Feb 2015 22:08:37 GMT

Ya I think the best solution would be to create 3 expressions. Just like you said, it would be a hassle to make sure that all the Year selections are linked to the Alternate State for it to change.

Best,