topic Re: On/Off button - when clicked on Clear On button does not go back to Off in QlikView

On/Off button - when clicked on Clear On button does not go back to Off

terezagr — Tue, 22 Oct 2013 15:29:26 GMT

Hi all,

I have been working on a project where using On/Off button to apply set filters. The button works perfectly, but problem starts when I click on Clear in the top menu...despite the fact that all selections are cleared, the button stays ON, but it should go back on OFF.

Please let me know if you have any solution for this.

Regards,

Tereza

Re: On/Off button - when clicked on Clear On button does not go back to Off

israrkhan — Tue, 22 Oct 2013 15:45:11 GMT

Hi ,

I think variable can not be clear,

but an idea is use a button to clear all with action "Clear All", and add another action to same button, that will be

"Set Variable" in set variable change the value to off or 0, try it, but i am not sure...

Button Actions:

Clear All

Set Variable

Re: On/Off button - when clicked on Clear On button does not go back to Off

Tue, 22 Oct 2013 15:46:54 GMT

Could you please upload a QVW file showing the button ?

If not, please provide details of the button insights..

You may be able to solve this problem using a variable in order to control de button On/Off sequence..

Re: On/Off button - when clicked on Clear On button does not go back to Off

terezagr — Tue, 22 Oct 2013 15:49:43 GMT

Hi,

I have clear selection button - where Clear All is applied...and it still does not change the ON button to OFF.

Re: On/Off button - when clicked on Clear On button does not go back to Off

terezagr — Tue, 22 Oct 2013 15:55:24 GMT

Hi Luis,

for the ON button

Apply Bookmark - bookmarkA

Set Variable - if(vOnOffButton='Show','Hide','Show')

for the OFF button:

Apply Bookmark - bookmarkB

Set Variable - if(vOnOffButton='Show','Hide','Show')

Thanks for help.

Re: On/Off button - when clicked on Clear On button does not go back to Off

Tue, 22 Oct 2013 16:06:18 GMT

Hi Tereza,

See attached example.

I´ve just changed the visibility condition.

Re: On/Off button - when clicked on Clear On button does not go back to Off

terezagr — Wed, 23 Oct 2013 08:23:17 GMT

Hi Luis,

unfortunately your solution does not work too....when you click on the button and the selection is made the button shows on, but then when you click on Clear all, the button should go back to state OFF...but it stays ON.

I would like to find a solution for this as it could be quite confusing for users to see that a button is still ON, despite the fact there is no selection made.

Re: On/Off button - when clicked on Clear On button does not go back to Off

p_verkooijen — Wed, 23 Oct 2013 08:32:04 GMT

Tereza,

The default Clear all has no effect on variables, only dimensions.

use a button with actions

Clear All
Set Variable vOnOffButton = 0

Also changed the On / Off button to IF(vOnOffButton=1, 'Off', 'On') instead of show conditionals

Re: On/Off button - when clicked on Clear On button does not go back to Off

flipside — Wed, 23 Oct 2013 08:32:47 GMT

Hi Tereza,

One solution could be to link the button status to a field. For example, create a table like this in your script ...

Button:

Load * inline [
Status
1];

Your button text may be something like this ..

if(GetSelectedCount(Status)=1,'On','Off')

And one of your button actions needs to select the value 1 in the field Status. When you click clear it will reset the button text.

Hope this helps

flipside

Re: Re: On/Off button - when clicked on Clear On button does not go back to Off

p_verkooijen — Wed, 23 Oct 2013 08:37:48 GMT

flipside's solution could work better than my suggestion, end users can use the standard clear all functionality

Also change the variable vOnOffButton to : if(GetFieldSelections(Status)=1,1,0)

Re: Re: Re: On/Off button - when clicked on Clear On button does not go back to Off

terezagr — Wed, 23 Oct 2013 10:49:32 GMT

Hi,

this would work fine for using a button, but I use text where is applied picture as background.

please see file attached.

Any suggestions for this case?

Re: On/Off button - when clicked on Clear On button does not go back to Off

flipside — Wed, 23 Oct 2013 10:56:06 GMT

You could lay the buttons over each other. Easiest way to do this is note the X-pos and Y-pos values (Normal mode) under Properties > Caption and apply to the other button.

Another option would be to load the images into your document using the Bundle command. These images can then be called using a conditional statement.

flipside

Re: On/Off button - when clicked on Clear On button does not go back to Off

offjunior — Wed, 23 Oct 2013 21:16:31 GMT

Good night!

I created a new button in your application that does what you need. I used the function GETCURRENTSELECTION () and seemed to work right. Check and reply me if that was what you wanted, if not reply me what is wrong with this working solution.

Attached hereto qvw your document.

Hug!

Re: On/Off button - when clicked on Clear On button does not go back to Off

terezagr — Thu, 31 Oct 2013 15:36:11 GMT

Hi Junior,

your solution was the one I was looking for Thank you!