topic Re: 'Clear' option should select possible values from a field. in QlikView

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

Anonymous — Fri, 27 Oct 2017 06:16:35 GMT

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

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

jonathandienst — Fri, 27 Oct 2017 06:20:36 GMT

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.

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

Anonymous — Fri, 27 Oct 2017 06:52:37 GMT

Thank you Jonathan.

My report has multiple tabs. So, If I Set Clear State, it gets applied to all the tabs. Instead, I need to Set Clear state for each tab individually. Please let me know if there is a way to do that .

Thanks in advance!!

Regards,

Rajalakshmi

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

Sergey_Shuklin — Fri, 27 Oct 2017 07:56:17 GMT

Hello!

Not sure will it be usefull, but you may be interested with:

Catch the Clear Button Hit

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

woshua5550 — Fri, 27 Oct 2017 09:18:54 GMT

why not create several buttons with different triggers for each tab you have?

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

Miguel_Angel_Baeyens — Fri, 27 Oct 2017 09:27:38 GMT

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.

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

woshua5550 — Fri, 27 Oct 2017 09:41:18 GMT

maybe you can use Macro to achieve this

check this

Sub SetClearState

select case ActiveDocument.GetLayout.ActiveSheetId

case "Document\SH01"

ActiveDocument.Fields("Location").ClearAllButThis

case "Document\SH02"

ActiveDocument.Fields("Customer").ClearAllButThis

end select

ActiveDocument.SetClearState

End Sub

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

woshua5550 — Fri, 27 Oct 2017 09:47:02 GMT

Macro will be triggered when you switch the tabs

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

Anonymous — Fri, 27 Oct 2017 11:03:23 GMT

Thanks Miguel.

I am already using a separate button for Clearing the selections and I am worried that the users might use the application provided button.

-Rajalakshmi

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

Anonymous — Fri, 27 Oct 2017 11:04:28 GMT

Thanks Dave . But as per the rules, I am not allowed to use macro. Thanks for the macro code.

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

Anonymous — Fri, 27 Oct 2017 11:09:29 GMT

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

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

Miguel_Angel_Baeyens — Fri, 27 Oct 2017 11:23:11 GMT

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

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

avinashelite — Fri, 27 Oct 2017 11:37:12 GMT

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

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

Sergey_Shuklin — Fri, 27 Oct 2017 14:34:01 GMT

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.