One option is to open the dasboard in desktop, make whatever selection state want when the Clear button is pressed, then on the menu click Selections | Set Clear State and save the document.
Now pressing Clear or Clear All will revert to the state you set above.
Footnote: I prefer to design my documents so that this sort of behaviour is not required, as it can be confusing for the users.
Thanks Sergey. It works perfectly for the entire document as a whole . But for my report, I would be requiring it to be sheet specific. i.e., the selections have to disappear for the next sheet when I press the clear button(without using alternate states). Please let me know if that can be done .
Thanks in advance!!
It will take a lot of background work, but you can try to use GetActiveSheetId() function to indicate current sheet and in variable trigger action you can create, replace or apply some bookmarks.
Bookmarks can be applied for special sheets on Clear Button hit and user wont notice this action.
But you should be really careful and point all the situations of user's behavior otherwise the project will be ragged.
Well, the "Clear" button in the menu always does exactly that: clear all values and the only way of modifying this behavior, as jontydkpi mentioned above, is using the Set Clear State, which applies to the whole document.
If you don't want this behavior, you need to stop using the Clear button, develop your own, and use bookmarks so each page stores its own status, so to say. You have an example of that behavior here.
Anyway, it would be counterintuitive for me if the same button performs two different actions in two different sheets of the same application.
maybe you can use Macro to achieve this
select case ActiveDocument.GetLayout.ActiveSheetId
Sample1.qvw 155.0 K