'Clear' option should select possible values from a field.

[Anonymous]

Hi All,

I have created a dashboard where there are various charts and filters. I have created a button which clears all the selections and retains only default selections. But , I wanted the 'Clear' option of the application to exhibit similar behavior. Please let me know on how I can achieve this.

Please find the sample attachment . Here, the 'Clear selections' button will clear all the selections made except the 'Location' filter. Please let me know how to have similar behavior for 'Clear' option of the application too.

Thanks in advance!!

Regards,

Rajalakshmi

[Anonymous]

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!!

Regards,

Rajalakshmi

[Miguel_Angel_Baeyens]

You can hide the toolbar if you want to, but it will be hidden for all apps, not only this one.

Document Extension Solution to hide buttons on the AJAX toolbar...and anything else

[avinashelite]

I feel the best way to handle this is to educate the users   not to use the default clear button other wise you end up in doing lot of background and it would be difficult to maintain too

[Sergey_Shuklin]

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.