Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
mayankraoka
Specialist
Specialist

filter to be limited for different sheet in document

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

1 Solution

Accepted Solutions
sudeepkm
Specialist III
Specialist III

please take a look at the solution attached.

View solution in original post

8 Replies
vishsaggi
Champion III
Champion III

Try this:

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

mayankraoka
Specialist
Specialist
Author

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

vishsaggi
Champion III
Champion III

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
Specialist III
Specialist III

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
Specialist
Specialist
Author

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

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')Capture.PNG

vishsaggi
Champion III
Champion III

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

sudeepkm
Specialist III
Specialist III

please take a look at the solution attached.

View solution in original post