topic How to clear the button selections in QlikView

How to clear the button selections

rkpatelqlikview — Wed, 13 Dec 2017 06:16:02 GMT

Please find the attached QVW. The selection should be clear when clicking on the clear. Color of the button should be normal.

Thanks

Re: How to clear the button selections

tresB — Wed, 13 Dec 2017 06:19:25 GMT

PFA

Re: How to clear the button selections

rkpatelqlikview — Wed, 13 Dec 2017 06:24:41 GMT

Thanks for your response Tresesco.

Instead of creating new Clear Button. We need to click on the clear then action should be performed.

Re: How to clear the button selections

tresB — Wed, 13 Dec 2017 06:27:15 GMT

That is system 'Clear', and I am afraid that it's behavior can't be modified to change your button color ( actually your variable value).

Re: How to clear the button selections

its_anandrjs — Wed, 13 Dec 2017 06:28:13 GMT

Set the selection Variables value to Zero by sheet event trigger.

Re: How to clear the button selections

rkpatelqlikview — Wed, 13 Dec 2017 06:41:25 GMT

No Anand.\

Its not working.

Re: How to clear the button selections

Anonymous — Wed, 13 Dec 2017 06:48:29 GMT

if(GetSelectedCount(Dimension)>0,Blue(),LightGray()) Add this condition inside color ->click->calculated-> then add this expression. Here Dimension is your field name.

Assuming that your Button functionality is to select a value from Dimension field

Re: How to clear the button selections

tresB — Wed, 13 Dec 2017 06:49:54 GMT

Well, I have found a work-around. You can use OnAnySelect trigger to handle it. PFA

Re: How to clear the button selections

tresB — Wed, 13 Dec 2017 12:17:24 GMT

Kumar,

It's important that you mark the right post/reply as 'correct', so that people looking for solution to similar issue/requirement get directed to right answer. Please mark 'correct' which is really correct answer.

Re: How to clear the button selections

rkpatelqlikview — Wed, 13 Dec 2017 12:40:49 GMT

Tresesco,

Thanks for your efforts.

Just i copied pasted in my application the same Buttons and declared variable vButton. But its not working i mean its not clearing

Re: How to clear the button selections

tresB — Wed, 13 Dec 2017 12:47:35 GMT

Have you also set OnAnySelect trigger like I did?

Re: How to clear the button selections

rkpatelqlikview — Wed, 13 Dec 2017 12:54:56 GMT

Now i did it.

If(len(getselectedcount())>0, RGB(0, 0, 255), RGB(192, 192, 192))

Re: How to clear the button selections

rkpatelqlikview — Wed, 13 Dec 2017 12:57:02 GMT

=if(len(GetCurrentSelections())=0,RGB(0, 0, 255), RGB(192, 192, 192))

Re: How to clear the button selections

tresB — Wed, 13 Dec 2017 13:03:00 GMT

Please realize that this trigger doesn't set the color of the button directly, it only sets the variable value. So try just this:

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

Button's color changes based on it's status, 'active' or 'inactive'.

Re: How to clear the button selections

rkpatelqlikview — Wed, 13 Dec 2017 13:21:21 GMT

sorry Tresesco,

Your QVW is working properly. But when am implementing the same things in application its not working.

Thanks in advance

Re: How to clear the button selections

rkpatelqlikview — Wed, 13 Dec 2017 13:29:48 GMT

PFA !

Re: How to clear the button selections

tresB — Thu, 14 Dec 2017 04:51:54 GMT

Interesting!

It seems that since your sample app is not having any data (read - field to check for clearance->OnAnySelect), qlik is probably not even triggering the OnAnySelect action assuming that there is nothing to clear. However, if you try with a dummy field loaded or try in the real application (which must be having data), this will work.