topic How to Clear Current Box Selection in QlikView

How to Clear Current Box Selection

Mon, 20 Jan 2014 12:27:59 GMT

Hi All,

I have a filter, where the options are A and B.

The Current Selection Box is displaying the value, even after clicking the Clear Selection option.

By default, it is displaying either A or B.

Can anyone help me with this?

Thanks,

Praveen

Message was edited by: Praveen Kumar Updated

Re: How to Clear Current Box Selection

Mon, 20 Jan 2014 12:36:36 GMT

May be that Filter is Locked...Right Click on that filter--->Un Lock and Click Clear

There is one dropdown Arrow near Clear Button...Click that dropdown you can find "Unlocak and Clear All" select it...

Thanks,

Selva

Re: How to Clear Current Box Selection

tresB — Mon, 20 Jan 2014 12:40:53 GMT

And, check if the 'Always One Selected Value' in general tab is checked. You have to uncheck that.

Edit: You might have to check if there is any hidden list boxes that are selected with same check mentioned above.

Re: How to Clear Current Box Selection

Mon, 20 Jan 2014 12:43:05 GMT

Hi Selva,

Thanks for your reply.

But, I didn't enable any lock options.

The filter which I have created is by using inline function only. May be is that a problem ?

Re: How to Clear Current Box Selection

Mon, 20 Jan 2014 12:47:25 GMT

No its not an issue at all.. Are you using any On Open or On Active Trigger for that field?.. Or check "Always One Selected Vale" as mentioned by tresesco...

Re: How to Clear Current Box Selection

Mon, 20 Jan 2014 12:55:08 GMT

Hi Tresesco,

Thanks for your reply.

I have selected 'Always One Selected Value' . The Thing is if I uncheck the box, it is showing as two tabs also to be selected.

Re: How to Clear Current Box Selection

Mon, 20 Jan 2014 13:28:53 GMT

Selva,

I am not using that Trigger options.

Re: How to Clear Current Box Selection

Mon, 20 Jan 2014 13:31:08 GMT

Hi Tresesco,

PFA

Re: How to Clear Current Box Selection

Mon, 20 Jan 2014 13:31:37 GMT

Hi Selva,

PFA

Re: Re: How to Clear Current Box Selection

tresB — Mon, 20 Jan 2014 13:35:58 GMT

PFA

Your dimensions of the charts were conditional in enablement (removed that)

Update: If you want that condition to be there then try second attachment.

Re: How to Clear Current Box Selection

Mon, 20 Jan 2014 13:57:30 GMT

Hi Tresesco,

EXp1_tres2.qvw is fine. But my requirement is bit different.

I dont need that "Always One selected value" to be unchecked.

I need it, because,

1. I need only one filter value to be selected once (No multiselect), thats why we have enabled it.

the file which I sent is as per my requirement.

The problem is,

The current selection is showing the value. even if we clear it.

Re: How to Clear Current Box Selection

Mon, 20 Jan 2014 14:01:26 GMT

Hi All,

Sorry.

Please find the updated file.

I dont need that "Always One selected value" to be unchecked.

I need it, because,

1. I need only one filter value to be selected once (No multiselect), thats why we have enabled it.

the file which I sent is as per my requirement.

The problem is,

The current selection is showing the value. even if we clear it.

Re: How to Clear Current Box Selection

sudeepkm — Mon, 20 Jan 2014 14:21:05 GMT

The current selection box will show whatever field selected. I'm not sure if the default behavior can be altered but I think we can manipulate it. In the Current Selection box properties you can change the text color so that it will match with the back ground whenever getselectedcount(yourfield)>0 this will hide the text but other columns like the "Status" and "clear Icon" will remain visible unless you remove that from the Current Selection Box properties.

Or you can have a thin textbox with layer top than the current selection box for the particular field which has one selected value.

Re: How to Clear Current Box Selection

Tue, 21 Jan 2014 06:35:42 GMT

This will make my font colorless even on selecting.

The problem is. I havent selected any filter here. But since I am using INLINE function for creating this List Box filter, By default, any of the one value is always selected.

I really dont know how to chage it.

If you see the Edit Script page, You can find my Inline function script.

The reason why I used inline funtion is, I need two column header names as a filter values.

Re: How to Clear Current Box Selection

tresB — Tue, 21 Jan 2014 06:46:38 GMT

Are you looking something that allows user to select 'ONLY one' value from the list and be able to clear as well?

Re: How to Clear Current Box Selection

Tue, 21 Jan 2014 08:51:33 GMT

Hi Tresesco,

Please see the document which I have shared yesterday. the Updated one.

That is meeting all my requirements. That is how I need the selections and display.

I am facing only one problem. Clear selection Box is displaying the value, even after clicking the CLEAR button.

I guess, you got my problem ?

Thanks,

Praveen

Re: How to Clear Current Box Selection

danialier — Tue, 21 Jan 2014 09:09:31 GMT

Hi Praveen,

You just need to uncheck the "Always One Selected Value" in the List Box Properties under the General Tab.

BR,

dani

Re: How to Clear Current Box Selection

tresB — Tue, 21 Jan 2014 09:33:59 GMT

Please understand that, one field doesn't get cleared if 'Always One Selected Value' is enabled for it even if you press 'Clear All'. And if one field has got to remain selected, it will be shown in the current selection box. There is no way to not show in the current selection box as not/nothing selected for one field which is really selected by user.

Re: How to Clear Current Box Selection

Tue, 21 Jan 2014 09:39:57 GMT

Thanks Tresesco.

Re: How to Clear Current Box Selection

richard — Tue, 21 Jan 2014 09:57:48 GMT

Try this:

1. Uncheck the "Always One Selected Value" option on the General tab.

2. Use a sheet trigger event on action "Select in Field" and give in or A or B to be selected when the sheet is activated.