Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Bookmark Question

Hi All,

How can i create a bookmark which excludes the same list of elements all the time even though the field elements changes or increases . For example see attached excel sheet if you see the one in grey color is my exclusion list of elements. Even though tomorrow if the customer group field elements increases my Bookmark should exclude the same list in grey color. Any help would be appreciated.

1 Solution

Accepted Solutions
swuehl
MVP
MVP

You can use a search in the field to exclude your customers. Then store this search as bookmark.

Even when you add new customers, the search will still filter on your condition.

See attached.

View solution in original post

9 Replies
satishkurra
Specialist II
Specialist II

I think it will behave the way you are expecting even though field elements increases/decreases.

Anonymous
Not applicable
Author

Satish, Thank you for your response. Its not happening like that, if tomorrow my list of elements increase then my exclusion list is having the new elements in them. If i missing anything, can you please email me any sample QVW file which you have done it. Thanks for your help in advance.

satishkurra
Specialist II
Specialist II

Sorry, unfortunately i don't have any...

Anonymous
Not applicable
Author

Hi Manish,

Please find the attached screen shots

swuehl
MVP
MVP

You can use a search in the field to exclude your customers. Then store this search as bookmark.

Even when you add new customers, the search will still filter on your condition.

See attached.

Anonymous
Not applicable
Author

hi Stefan, Sorry for the late response how can i search in the list box like the way you can searched. thanks for your help in advance...

swuehl
MVP
MVP

Just click on the caption of the list box and start typing.

Use one of the search modes:

The Search String

Apply the search to filter you current data. The current selection box should show your search string, not the selected values.

Now create a bookmark from your current selection.

Anonymous
Not applicable
Author

If i use Wildcard search it is searching for the customer group i have searched. For example if i want Millwork , Skyrun it is not able to find. Please correct me if i am doing anything wrong and sorry to ask you the same question again and again...

swuehl
MVP
MVP

Not sure I understand what you are telling me.

Could you just post the search string you are using to exclude the values from your sample data you posted in a previous post and indicate what is not working as expected when you are creating the bookmark?