Bookmark Enable

[mishraamit2485]

Hi All,

I have one straight table which get enables after selecting some fields for ad hoc reporting, after selecting some fields i'm bookmarking it with applying some certain filter condition.

My question is can i display that bookmark only if it satisfies all the filter condition else it should not come.

For e.g, suppose i have one employees table and I have to bookmark it with these filter condition

1) Salary > 1000K

2)Location = NY

3)Depart = IT

So i want the bookmark to display only if all the three condition is getting satisfies...

[Gysbert_Wassenaar]

No, the bookmarks will always be visible in the bookmark menu until you delete them.

[maleksafa]

you need to use advanced search to create the bookmark.

add a list box for salary, right click and then advanced search, there you will be able to filter for sales > 1000 (>1000), then select the location and depart, and save the bookmark.

[mishraamit2485]

Sorry to say but i think u r not getting my point my bad...question is i want to display bookmark if all the filter condition is getting satisfied suppose we do not have any employee with Location NY(But i created the bookmark by entering some test data for location in my QVD(using some if else).

Now point is in server if data is not there it is coming with only 1 condition that is salary > 1000...

As now we do not have any data for NY so it is not giving the third filter(i.e Depart = IT) as 2nd filter is not there so qlikview is not proceeding with the 2nd and 3rd both filter.

[mishraamit2485]

No no i do not want to created a list box i have one straight table and want to display the bookmark in that only...

only condition is it should display the records if and only if it satisfies all the filter condition....

Suppose I have 100 records..

After 1st filter total no of records = 90

After 2nd Filter total no of records = 70

After 3rd = 50..

And now what is happening if no data is there in server for 2nd Filter QV is showing 70 records in the bookmark and it is not applying the 3rd bookmark because i guess it has missed the 2nd filter( as no data is there)..

What i want the bookmark should be enabled if all the filter conditions are getting satisfied...