Webi 4.1 Hide/display a specific serie of data in a line chart?

[former_member597137]

Hi,

Is it possible to hide or display a specific curve on a line chart?

Let say for example I want to show only the blue curve, is there a way to hide the green one?

I tried with an input control but it doesn't work as the measure is calculated and when it filters it changes the calculation. Is there a way to select directly on the graph which lines to display?

Thank you for your help!

Marc

[Tom_N8]

Hi Marco,

You can achieve this with some imagination using Input Controls. In my example below I am showing League Positions and Points by Season with an Input Control to choose between showing both Positions and Points, Positions only, or Points only. The original objects used in the report are:

• [League Level] to show whether the team played in the first, second or third division during a season,
• [PTS] to show the points accumulated in a season,
• and [Season].

Follow and apply these steps:

1. Create a new variable [Show and Hide] =1 This variable will be used for the construction of the Input Control and the other two variables we need
2. Create a measure variable [League] =[League Level] Where([Show and Hide] InList(1;2))
3. Create another measure variable [Points] =[PTS] Where([Show and Hide] InList(1;3))
4. Now, create your Input Control. I called mine "Select Graph Options" with the description "Select one of the three options to show:1 - League Position and Points by Season2 - League Position by Season3 - Points by Season" for the tooltip, a custom LOV (values 1, 2 and 3), and a default value 1.
5. Next, right-click your graph, select Assign Data and replace your [League Level] and [PTS] with their corresponding [League] and [Points] measure objects, respectively.
6. Now, go to Format Chart / Title and select manual Label Mode with the following formula =If([Show and Hide]=1) Then "1 - League Position and Points by Season" ElseIf([Show and Hide]=2) Then "1 - League Position by Season" ElseIf([Show and Hide]=3) Then "1 - Points by Season"
7. Also, in Format Chart go to Value Axis and set minimum and maximum fixed values, i.e. in my example "0" and "50" respectively.
8. Confirm with "OK"
9. Select 1, 2 or 3 in the Input Control and see how only one or both of the data series gets displayed:

Kind regards,

Tom

[former_member597137]

Hello !

Thank you for you help and really detailed explanations!

It worked perfectly !!

Thanks!