Discussion Board for collaboration related to QlikView App Development.
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.
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.
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.