When I enter the sheet 'Orders' I only want to see the orders with OrderStatus=O. I don't want to see the orders with OrderStatus=I.
This works with Sheet Properties (Orders) --> tab Triggers --> OnActivateSheet --> Button Edit Action(s) --> Action ' Select in Field' --> Field 'OrderStatus' and 'Search String' O. But when I select in other sheets more filters and this selection doesn't include orders with OrderStatus=O and I'll open the sheet 'Orders' again all my current selections are cleared. How do I solved the problem of clearing my current selections?
I've tried the solution, but it doesn't solve my problem.
I want Qlikview to save my current selections (this selection doesn't include orders with OrderStatus=O) while I enter tab 'Orders'. Because this tab doesn't contain data, Qlikview is clearing automatically his selections. Ideally I want to see the message ' No data' and save my current selections, but how I realize that?
It sounds like QV is clearing the selection because the existing selections and the OrderStatus=0 selection are mutually exclusive. In such a case, QV assumes that the most recent selection should apply and clears the old selection.
If you want to preserve the prior selections, I suggest that you add to your trigger a Replace Bookmark action to save the selections in OnActivate, and add a trigger to OnDeactive to apply the bookmark to reinstate your prior selections.
Hope that helps
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
I've tried your solution, but unfortunately it doesn't work. Do you have un other solution?
My current selections contains only records with Orderstatus=I. When I go to tab 'Orders' the next triggers are being activated in OnActivate:
1. 'Create Bookmark' to save the current selection with Orderstatus = I
2. Select field with field 'OrderStatus' and Search String 'O'
3. 'Replace Bookmark' to add the selected field 'OrderStatus=O' to the current selections with OrderStatus=I.
Now you can see the mutually exclusive of Orderstatus I and O. I want Qlikview to ignore the selection of OrderStatus = O if the current selections only contains records with OrderStatus I. On this way the current (prior) selections will preserve.
if you wanted to clear only one field when you open a sheet or click any button what you have to do this: In the actions select Select in Field and give the field name under the Field space available and where ever it says search string: give any value like this 'xxxx' which is not present in the data. for your reference see the attched screen shot.
if you need further assistance attach a sample document and your requirement explanation.
If the current selections only contains records with OrderStatus = I and you enter sheet 'Orders' with the default selection OrderStatus =O, then I want to see the message 'No data to display' in sheet 'Orders'. When you leave this sheet I want the current selections stays active.
I'll hope this explanation will be more clear for you.