topic Re: Change button value, when clear all selections is clicked. in QlikView

Change button value, when clear all selections is clicked.

Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I have a button that changes the filtering of certain fields when it is clicked. The text on the button changes from order to request on clicking and vice versa (this is achieved by creating a variable vhide and when the value is 1 it shows order).

When i click the clear all selections button the button shows the same value (order or request) . I want the button to show 'Order' each time when I press clear all selections button.

Thank You.

Re: Change button value, when clear all selections is clicked.

avinashelite — Mon, 08 May 2017 14:33:56 GMT

Your talking about the default clear All button ? if yes then it won't re set the variables , you need to create a custom button and add the action to cleat all selections + Action to clear all the required variables

Re: Change button value, when clear all selections is clicked.

Mon, 08 May 2017 14:39:18 GMT

Can i create a button that clears all variables when the clear all selection button is clicked? I would make this button invisible.

Re: Change button value, when clear all selections is clicked.

Sergey_Shuklin — Mon, 08 May 2017 14:44:32 GMT

Hi, Rahul!

Try to catch when all selections are clear with "=if(isnull(GetCurrentSelections())=-1,'Order',...".

Re: Change button value, when clear all selections is clicked.

Mon, 08 May 2017 14:49:00 GMT

Is there absolutely no workaround for doing that?

Re: Change button value, when clear all selections is clicked.

CarlosAMonroy — Mon, 08 May 2017 15:00:43 GMT

Are you talking about the button name only?

It can changes if you do the following condition:

Button Name:

=if($(vVariableName=1,'Order','Request')

Action->External->Set Variable:

=if($(vVariableName=1,0,1)

Hope that helps,

Carlos

Re: Change button value, when clear all selections is clicked.

Mon, 08 May 2017 15:13:00 GMT

what is this code doing? I want the button to show order , when i click clear all. Your code just changes the name of the button when it is clicked. I have already done that . I need a way to show order when clear all selection is clicked basically go back to the original variable value.

Thanks

Re: Change button value, when clear all selections is clicked.

Mon, 08 May 2017 15:39:16 GMT

You can use =if(IsNull(GetCurrentSelections()),value,value) to change the value of a variable. I am just not able to do it though.

Re: Change button value, when clear all selections is clicked.

CarlosAMonroy — Mon, 08 May 2017 15:46:41 GMT

You can try this:

=if(len(GetCurrentSelections())=0,value,value)

That works perfectly.

Carlos M

Re: Change button value, when clear all selections is clicked.

Peter_Cammaert — Mon, 08 May 2017 15:52:56 GMT

You cannot hook the Clear All button (it's a standard Windows toolbar button which doesn't even exist in the Ajax client), and in QlikView you cannot detect any triggers or messages sent by Windows objects.

As Avinash already correctly stated, you can however simulate the effect you want to obtain by duplicating the Clear All button as a regular QlikView button, adding a Clear-All action and adding a Set Variable action to resrt the label variable to a default value.

Re: Change button value, when clear all selections is clicked.

Sergey_Shuklin — Mon, 08 May 2017 16:47:33 GMT

When you hit a Clear All button the value of GetCurrentSelection() function becomes null. So, all you need is write one more condition in button text like I wrote above:

=if(isnull(GetCurrentSelections())=-1,'Order',if(vhide=1,'Order','Request'))

See the picture below:

After I clicked "Cleat All" button the text has changed:

Hope it helps!

Re: Change button value, when clear all selections is clicked.

Mon, 08 May 2017 17:26:55 GMT

How are we able to assign a bookmark to the clear all button then? I assumed if we are able to assign something to the clear all button we could also change the variable associated to a button.

Re: Change button value, when clear all selections is clicked.

Mon, 08 May 2017 17:31:43 GMT

It didn't work when i incorporated it in my code :

=if(isnull(GetCurrentSelections())=0, 'Current Filter: Order Date',

if(vhide=1,'Current Filter: Request Date', 'Current Filter: Order Date'))

Is that right ?

Re: Change button value, when clear all selections is clicked.

Sergey_Shuklin — Tue, 09 May 2017 04:59:11 GMT

Hi, Rahul!

It wouldn't work because you set your first codition as isnull(GetCurrentSelections())=0.

Your expression sounds like "When something is selected pick 'Order date'...", but if I understood you correctly you want to get 'Order date' each time when you press clear all selections button. Solving that case try to use isnull(GetCurrentSelections())=-1, it means "When nothing is selected pick...".