filter to be limited for different sheet in document

[mayankraoka]

Hi Team,

I have a list-box say product and 2 sheets.In 1 sheet i can show all the values for product list-box. But in sheet 2 i can show only few values due to Confidential data.For ex.Product has values A,B,C,D,E.In sheet 2 I can show A,C,D related data only .

I want the list box to be same and dont want use alternate state as the user should be aware of what he has selected.I know one is to have flags.

Can anyone tell the best approach.

Regards,

Mayank

[vishsaggi]

Try this:

IF(Product = 'A' OR Product = 'C' OR Product = 'D', Product)

[mayankraoka]

I want that list box will show only this option in sheet2

[vishsaggi]

Yes, in the sheet 2 -> Add listbox Product -> In the General tab -> Field drop down select expression and type in this expression ? Did you try this way ?

[sudeepkm]

Do you have a sample qvw that you can share?

I think the best approach is to handle it at data load.

You can create a flag per product type and you can hide those ones which has this flag enabled/disabled accordingly on sheet 2. You can lock the flag field so that customers wont be able to select those values from the list or use hide excluded.

[mayankraoka]

Hi Sudeep,

I have attached the sample app for you.In this assume Main sheet have State field have all the values .But in sheet 1 ! I need the state field should show only 6 values as AL,AR,AZ,CA,CO and FL.

Regards,

Mayank

[vishsaggi]

You can use this way in sheet 1 listbox. Will this work?

= Pick(Match(STATE, 'AL','AR','AZ','CA','CO','FL'),'AL','AR','AZ','CA','CO','FL')

[vishsaggi]

You can use this Pick(Match.... in your load script and display as a separate column.

[sudeepkm · Accepted solution]

please take a look at the solution attached.