Button or checkbox to show/hide data series in a chart

[hobanwashburne]

Can someone link to an example of using a a checkbox or button to show/hide a data series in a chart?

[#2]

There are definitely tons of links out there. Simpler for me to explain, then go look

1) Create a variable and call it vShowHide

2) In your button have a conditional statement that on click set variable value to either 1 (show) or -1 (hide) by applying a multiplication of -1 each click i.e. 1 * -1 = -1 and -1 * -1 = 1 and so forth

3) In your chart object, have a calculation condition that says if(vShowHide = 1, 1, 0). Conditional calculations always interpret 1 as true and 0 as false

Hope that helps, and if I come across an example, will share link

cheers,

Byron

[MayilVahanan]

Hi

Please find attachment

[jaimeaguilar]

Hi,

check the following example for hide/show data series with either buttons or listbox,

regards

[v_iyyappan]

Hi,

Check the below link to show and hide the charts using the button

Re: How to hide chart on button click?

Show and Hide a Chart using a button

Regards,

[hobanwashburne]

Not exactly what I was looking for. I do not want to show/hide the entire chart, just a given data series within that chart. For example, if a bar chart displayed monthly sales for three employees. I then add a forth data series: average monthly sales for all three employees. Then a fifth: average sales for all employees last year. The chart would get rather crowded if it always displayed all 5 data series. So I want the option to show/hide (via button) the calculated data series (averages).

[#7]

hi,

Am new to Qlikview,i have the same problem.

I got the logic to be used but can u tell me with syntax to set variable vShowHide by applying multiplication.

[jaimeaguilar]

Hi,

maybe this is what you're looking for,

Please refer to the example,

regards

[#9]

Thank u Jaime

This is what exactly am looking for