Hide/Unhide Charts based on Multiple selections in a List box ?

[#1]

I have a requirement where chart A should be displayed if I have A as a selection in List box. or

Chart B should be displayed if I have B as a selection in List box. And if they select A and B chart B should be selected.

Where i am facing problem when they are selecting more than one

What would be the best way to do it.

[Anonymous]

You could set the listbox to be "Always one selected value" under the listbox properties?

[#3]

Thanks Johannes,

But my client wants multiple selections.Is there is any best way to do it.

[sujeetsingh]

Just go on dispaly conditional for that chart

[#5]

HI ,

I writing the condition in layout .All I have three reports .If they click A in list box, then report1 should visible for that I am writing condition in layout  var=A like that If they click B in list box ,then report2 should visible .Till that there is no problem .My client wants Multiple selection in List box .when they select both A and B at the same time I need to show Report2 .

when i am writing the condtion Var= A and Var=B it is not working

Tell me is there is any way around to solve this problem?

[#6]

HI

PFA for reference.Need provide the sol ASAP

Thanks

[er_mohit]

for multiple selection you have to wirte code  in macro..

hope it might be helps you

[#8]

Thanks mohit for the info,Can you please let me know is there any another way to slove this problem as we can't use Macro's in our org.

[jagan]

Hi,

No need to write any macro.  PFA file for solution.  Hope this helps you.

Regards,

Jagan.

[abhijain · Accepted solution]

Hii ,

you can do this by using the wildmatch function.

Please see the attached file for the example