Display chart based on a value from the selction box

[shamitshah]

Hi,

I want the chart only to appear based on a selection from the list box.

For example list box called Project with values 11,12,13

I want the chart hidden and only appear on the selection of either 11,12,13

I tried the GetFieldSelections(Project)='*' in  Chart Properties ->Layout -> Conditional but does not seem to work

Any ideas?

[Anonymous]

Hi Shamit,

Kindly try it

Project = '11' or Project = '12' or Project = '13' in in  Chart Properties ->Layout -> Conditional

Thanks

[tamilarasu]

Hi Shamit,

=Wildmatch(GetFieldSelections(Project),'11','12','13')>0

[shamitshah]

How about where I have quite a huge number of Projects to chose from? I have only included 3 project numbers in the example above. In reality, there will be more.

Thanks

Shamit

[tamilarasu]

Just a quick question. You want to display the chart if there is only one selection (not multiple) in the listbox. Am I right?

If yes, then try like

=GetSelectedCount(Project)=1

[shamitshah]

Hi Tamil,

Either one or multiple selections (i.e. both).

I am not sure what syntax I should use to capture all the projects in x below

=Wildmatch(GetFieldSelections(Project),x)

Thanks

[tamilarasu]

How about this?

=GetSelectedCount(Project)>0

[shamitshah]

I tried that, but it does not hide the table initially.

Is there anything else I need to do to hide the table?

[tamilarasu]

Shamit - It nothing is selected in the "Project" field, it will automatically hide the chart. Have a look at the attached file.

[tresesco · Accepted solution]

You used GetFieldSelections(). Try using GetSelectedCount()