Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
shamitshah
Partner - Creator
Partner - Creator

Display chart based on a value from the selction box

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?

1 Solution

Accepted Solutions
tresesco
MVP
MVP

You used GetFieldSelections(). Try using GetSelectedCount()

View solution in original post

14 Replies
Anonymous
Not applicable

Hi Shamit,

Kindly try it

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


Thanks

tamilarasu
Champion
Champion

Hi Shamit,

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

shamitshah
Partner - Creator
Partner - Creator
Author

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
Champion
Champion

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
Partner - Creator
Partner - Creator
Author

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
Champion
Champion

How about this?

=GetSelectedCount(Project)>0

shamitshah
Partner - Creator
Partner - Creator
Author

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

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

tamilarasu
Champion
Champion

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

tresesco
MVP
MVP

You used GetFieldSelections(). Try using GetSelectedCount()