Conditional Show of the values in the list box based on the sheet selected?

[Anonymous]

Hi

I need to only specific values in the list box filter based on the Sheet selected. All values in the list box need not appear if these are not pertinent to the tab. Is there a way to do a conditional show based on the sheet selected?

[anushree1]

Hi,

Is this what you are looking for

[effinty2112]

Hi Sanjyot,

                         Add a listbox by left clicking on the screen and instead of selecting Select Fields ... , click New Sheet Object >> Text Box.

Instead of picking a field from the list go to the bottom of this list and select <Expression>. This will allow you to enter an expression that will define a calculated dimension.

This could be something as simple as an if statement such as:

=if([Product Group] = 'Shoe', [Product Code])

so if your sheet is all about shoes your list box will return the product code for shoes and not raincoats.

cheers

Andrew

[Anonymous]

Hi Andrew

I have tried this approach but doesnt seem to work .in the list box i chose expression and entered the below expression using if condition

=if(GetActiveSheetId()='SH01',Application ='ABC')

I need to show specific applications when a particular tab is selected.

[effinty2112]

Try:

=if(GetActiveSheetId()='Document\SH01',Application ='ABC')

When you look at your sheet properties tab it might say SH01 but place a textbox on the sheet with expression

=GetActiveSheetid()

Cheers

Andrew

[Anonymous]

Thanks..It worked to some extent but I am getting values 0,-1 in the list box. My expression for the list box is as below

=if(wildmatch(GetActiveSheetId(),'Document\SH01'),Application ='Erwin')

I get 2 values in the list box i.e. 0 and -1. When I select 0 table show all values other than 'Erwin' and when i click on -1 in the listbox it gives me the selection by Erwin